Hello forum
I'm new here, but haven't been able to find anything on this subject. I'm very new to VBA, however I'm pretty sure that it can handle my request, but cannot figure out how.
I have a table looking like the one in pic1.PNG. It carries on like that in 698 rows (including blanks), but might be larger (or smaller) than that in the future. There is no firm number of variants per product name and no firm number of product names per product group.
I would like to excel-normalize it to the format shown in pic2.PNG, eventually with the dimension-colum by itself (then'll concatenate myself)
Thanks alot - appreciate any input!
Bookmarks