Formatting issue for an itemized list

While testing out the generously donated coding for a formatting issue that converts a .html file into a usuable Excel file, I ran into an unexpected issue.

I have instances where multiple items are sharing these same item number (yes this does not make sense to me either).

The coding formats data from a 13 row structure, but in instances where there is an itemized list for one number the data is only 3 rows long.

If anyone could help in creating coding that can expand those 3 row data sets to the 13 rows neeed for the original coding, by drawing from the last normal 13 row data set you would be making life far more enjoyable for myself and a lot of other people.

I have attached the test file. It includes the original structure breakdown (explained from columns A-D, and the coding to address my original formatting issues. In addition I added explanations on what I am trying to have accomplished with a full breakdown in Columns E-J (rows 160 and below). Please let me know if my attempt at an explanation is still unclear and thanks in advance for any support that you can provide.


Thanks again,

D