I've found some similar solutions, but can't seem to alter them to fit my needs.
I've got 12 columns of data. The quantity ordered is in the 7th column of data. I want to have the row repeated so there is one row for each item ordered, with a new column inserted in the 8th column to count which row number it is for that order. Some cells may be blank, but not the quantity ordered. I want the copied results in a new sheet.
Example:
OrderNum PO ProNum City Mat Desc Qty OrigDate CompDate BOrder ExpDate Notes
1 A1 46 NYC 46C Tag 3 12/20/2015 01/15/2016
2 A2 47 NYC 45B Top 2 12/20/2015 01/15/2016
End Result in new sheet:
OrderNum PO ProNum City Mat Desc Qty Count OrigDate CompDate BOrder ExpDate Notes
1 A1 46 NYC 46C Tag 3 1 12/20/2015 01/15/2016
1 A1 46 NYC 46C Tag 3 2 12/20/2015 01/15/2016
1 A1 46 NYC 46C Tag 3 3 12/20/2015 01/15/2016
2 A2 47 NYC 45B Top 2 1 12/20/2015 01/15/2016
2 A2 47 NYC 45B Top 2 2 12/20/2015 01/15/2016
advTHANKSance
Bookmarks