That's quite a brilliant run-through for dealing with poorly formatted tables; thank you for posting
@learnspreadsheets5 ай бұрын
Thanks so much! Glad it is useful!
@kebincui6 ай бұрын
Brilliant 👍 thanks David❤
@learnspreadsheets5 ай бұрын
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