Again, thank you snb, you're great. I appreciate your time and help very much.

I have one more dilemma that you may be able to address.

It seems you have the word "Brand" hardcoded in the code to add sequential numerals thus leading to the headings in this example..... "Brand 1..Brand 2...Brand 3..) but I actually need the code to use the exact name that is populated across the column headers because in practice those place holders will actually be named with real product brands.
.
Can you give me one more revamp with references to the actual names populating the columns?

Thank you Sir/Ma'am. Again, much appreciate your time and effort.