Unpivot column pairs in Power Query for Excel & Power BI

[@cadoova_andrew]

That's quite a brilliant run-through for dealing with poorly formatted tables; thank you for posting

[@learnspreadsheets]

Thanks so much! Glad it is useful!

[@HaHa-gy5vg]

You are the man for this! Subbed!

[@learnspreadsheets]

Thanks for the sub! 😃

[@HaHa-gy5vg]

@learnspreadsheets Dude this was brilliant. I used to to convert some ugly wide data into this tall and skinny format. It was immediately very useful for analysis.

[@williamarthur4801]

That was great, I must get to grips with unpivoting / pivoting, I often end up creating multiple lists, and table to column / rows which then need zipping, all to avoid pivot .

[@learnspreadsheets]

Absolutely! Unpivoting is one of my favourite things in Power Query

[@kebincui]

Brilliant 👍 thanks David❤

[@learnspreadsheets]

Glad it’s useful!

[@hichamhadj9640]

Brilliant

[@learnspreadsheets]

Thanks!