Forum Discussion

Mike86's avatar
Mike86
Regular Visitor
7 years ago
Solved

Use Power Query to restructure a wide table into a narrow one grouped by product

Hi, I'm looking to transform a very wide table (with 490 columns!) into a narrow one. At the moment, my table has four columns of general data, and then 54 columns for each of 9 different products, ...
Need Help
parry2k's avatar
parry2k
Super User
7 years ago

Mike86 can you share sample data and that will help to provide the solution.

Mike86's avatar
Mike86
Regular Visitor
7 years ago

Appreciate you looking at this. Here's a link to the demo data:

Dropbox File

 

Let me know if this works for you.

 

Thanks,

 

Michael

    • Mike86's avatar
      Mike86
      Regular Visitor
      7 years ago

      Many thanks - a very neat solution. Really appreciate your help!

      M