Forum Discussion

P_D_G's avatar
P_D_G
Resolver III
5 years ago
Solved

Pivot table based on multiple values / rows to columns

Hi all,   I have the below dataset and I'd like to have it in a new format (2nd table).   I've already created this in Power Query by pivoting the table in 2 separate queries: 1) pivot based on ...
Need Help
  • P_D_G's avatar
    P_D_G
    Resolver III
    5 years ago

    Semms good, thanks for the idea! So it's still a lot of clicks but at least don't have to worry about multiple tables, good stuff.