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!

[@kebincui]

Brilliant 👍 thanks David❤

[@learnspreadsheets]

Glad it’s useful!

[@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