Convert 912 rows and 16 columns into 2 columns....with a twist

Hello All, I've got a spreadsheet with 912 rows and 16 columns, each is row contains a product model # and the 1 to 15 colours that are available for each model. I need to convert this to a verti...

excel

SergeiBaklan
Jul 29, 2020
kcb410

You may open the file, Data->Query and Connections, on the right pane double click on query (or Edit from right click menu), query editor will be opened, here you will see the steps

Olli Haavisto

Copper Contributor

Jul 29, 2020

kcb410

Here is an excamble file with which you can test the idea.

ColorsFromRightToBelow.xlsm18 KB

kcb410
Copper Contributor
Jul 29, 2020
Olli Haavisto
Thank you. I'll take a look at this file later today.
- TheAntony
  Iron Contributor
  Jul 29, 2020
  kcb410 , here's the unpivoted file using PQ...
  Options Product Colours.xlsx85 KB
  - kcb410
    Copper Contributor
    Jul 31, 2020
    TheAntony
    Thanks! That's perfect.

Forum Discussion

Convert 912 rows and 16 columns into 2 columns....with a twist

Resources