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