Hello,
I'm not sure if this is possible. Any assistance would be appreciated.
I have about 20 columns headed things like Product Number, Size, Colour, Weight etc
So for example, one record might be something like:
Product number Size Colour Weight Col5 Col6 Col7 Col8 etc 32456 Large Blue 10kg etc etc etc etc etc
I have about 10,000 of these records.
What I need is to rearrange them in another sheet which just has 3 columns.
Product number
Attributes
Values
A record would look something like
Product number Attributes Values 32456 Size Large Colour Blue Weight 10kg etc etc etc etc etc etc
Is it possible to transform the first format in the first spread sheet to the second format in the second sheet?
Thanks
Bookmarks