Analyzing cell contents, inserting a number of rows, and transposing

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

Here you go:

Please Login or Register  to view this content.

please find attached spreadsheet for example.

No problem james_black

Glad I could help.

Can you please mark this post as solved by:

- Go to original post
- Click Edit
- Click Go Advanced
- Select [SOLVED] from the prefix dropdown
- Save Changes

Cheers! & have a great weekend!