PDA

View Full Version : cut entire row and paste many times as quantity - Tables



garko75
03-01-2016, 07:13 AM
Hi All

I am working with on Excel 2013.
I have a table with three columns (Item, Quantity, Taggable) in one sheet and I need to cut (entire row) the item marks as taggable in another sheet and paste many times as related quantity. Somethink like this:

start table1

Item Quantity Taggable
Item1 2 Yes
Item2 3 Yes
Item3 1 Yes
Item4 4 No

Sheet2
Item
Item1
Item1
Item2
Item2
Item2
Item3
Item4 (one time because it is No taggable)

Could you please help me ..
Thanks
Garko