@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.
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 .
That's quite a brilliant run-through for dealing with poorly formatted tables; thank you for posting
Thanks so much! Glad it is useful!
You are the man for this! Subbed!
Thanks for the sub! 😃
@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.
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 .
Absolutely! Unpivoting is one of my favourite things in Power Query
Brilliant
Brilliant 👍 thanks David❤
Glad it’s useful!