Forum Discussion

WTAS80486's avatar
WTAS80486
Icon for Helper IV rankHelper IV
3 years ago

How to pivot Based on multiple columns in power query

Hi,

 

This is the table I have

 

 

 

 

 

But I need to pivot it to look like this in power query for Each ID

 

 

 

Thanks!

 

 

 

Need Help

1 Reply

  • datawailor's avatar
    datawailor
    Icon for Advocate II rankAdvocate II
    3 years ago

    Dont have a sample dataset to test this but I'd pivot on everything but the ID field then unpivoton everything but the id field and that should flatten the data out by id and then you may need to rename some fields perhaps but that should do it.