i am trying to work out to create duplicate rows in a spreadsheet, yes create duplicate rows. Everything so far i can find is to delete duplicate rows.
Problem being is that i have information such as,
Type Handed Qty
Green Door | left handed | 3
Red Door | left handed | 2
so i need to create in another worksheet
Green Door | left handed | 3 | 1
Green Door | left handed | 3 | 2
Green Door | left handed | 3 | 3
Red Door | left handed | 2 | 1
Red Door | left handed | 2 | 2
Any help greatfully accepted
Bookmarks