How to RESHAPE Multi-Column Stacked Data into a table with Power Query

[@decentmendreams]

Thanks and awesome trick. Question: what is the purpose of the integer column ? Could you not have gotten the modulo just from the index column ?

[@biwithgurpreet]

Thanks Micael. The "Integer-Division" column marks the record ID for each record whereas the "Index Column" after the modulo operation, contains the line id of each value within a record. I hope this is helpful

[@aiswaryasanthosh7878]

Would it not still work if there was not integer column?

[@aiswaryasanthosh7878]

Also can u do a video on how to do the reverse in power query
I have a problem where I have to horizontally stack data

[@fernandocardinali1683]

This trick is really useful! Excellent video, very well explained and quick to watch! Thank you so much!

[@WilliamSymonds-i5z]

Amazing video thanks mate, I’ve an got an exam coming up where I need to utilise power query so this was a massive help

[@biwithgurpreet]

That’s great. Best wishes for the exam

[@imranahamed1862]

Sir, I am grateful to you for this particular video. It has been of tremendous use. God bless you 🙏🏻
Take ❤

[@biwithgurpreet]

Thanks Imran. Best wishes

[@Luciano_mp]

Very good man! Thank you!

[@biwithgurpreet]

Thanks