Convert Matrix Style Data into Stacked Rows preserving identifying row values

[snb]

From where do those 'actual names' originate ?

[normonster]

From where do those 'actual names' originate ?

Hi snb....the 'actual names' are populated across the column headers. In this example I just typed in Brand1, Brand2, etc...but in practice these will be actual products names like Gorilla, BigOne, Masher...etc

The code will need to obtain the names from the text in the first row along the columns.

God I hope you can help me bro. I ran out of time and need to do this work tomorrow.

Thank you so much.