Hello Forum members - I am not a programming expert but would appreciate any help on the following
In the attached spreadsheet I am trying to turn the 'Before' tab into the 'After' tab
The steps I want to complete are:
On the ‘Before’ tab
In column H there is a comma separated string of product numbers
Steps
1.Count the number of product numbers - 1 (number of commas)
2.Duplicate that number of rows below the current row
3.Transpose all those product numbers so one is in each of the rows created (in column H)
4.Duplicate those contents of column H into column A
5.Go to the next row, column H and repeat from step 1
6.Until reaching the end of the spreadsheet
The end results are shown on the ‘After’ tab
The number of products in column H will ALWAYS be >=1
Bookmarks