Unpivot Cross Tabulated Data with Multiple Headers and Columns
Check out our newly launched M Language course ↗️ - goodly.co.in/learn-m-powerquery/
Learn how can you convert (unpivot) a cross tabulated data with multiple (nested) headers and columns into a tabular format.
Another similar posts is here - www.goodly.co.in/unpivot-data...
For more tips and tricks, hop over to my blog at www.goodly.co.in
- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
- - - - Blog - - - -
www.goodly.co.in/blog
Пікірлер: 70
Check out our newly launched M Language course ↗ -
Before I start your video I am hitting liked button. Small request please share such dummy files for our practice. I m learning....GOOD LUCK one of your admirer & fan.
I was struggling for days and then i came across your video. Thank you for this master piece.
how to do this in google sheets?
Sir,I am new to power bi(learning), could you please share sample exel file links in underneath your video,so that it is very helpful for me a lot to practice.....
This is the first time I am commenting on a video. If I am complimenting this must be great video. Wishes 🎉🎉
1 question, before loading data in power query, u have to convert turn data into table format, but if u turn data into table format, then would not be able to apply filter as per my requirement, and secondly, source who is handling/ preparing this data probably also may not be comfortable if he/she convert it into table format...
wow man you nailed it spot on. we just did for 3 headers. A big salute from Canada....!!!
This has been a problem I have face for years and never known an easy fix, you have saved me hours and hours of work! Can’t thank you enough
Can you please confirm how was it added in power query? I didn't see you converting Excel data into table. Then how was this added to make it refreshable?
How do you make month which really should be a column and not repeat hundred or thousands of time, so have Jan feb. march..... as unique columns ?
Thank you for this master piece. You just saved the day.
Super Thanks from me, a lot. Very helpful.
Perfect simplification!
Great job. I need to study this in detail, but this use case of multiple column headers and row columns comes up a lot. You're solution is a really good one. Many thanks.
I was just looking for this exact thing. Thanks bro! You're a legend!
Thanks sir, this helped a lot!
This was easy to follow and helped me get my task accomplished! Thanks!
Very well explained and helpful. Thank you!
Hi Chandeep, can't thank you enough for sharing these business cases. They actually save the day for people like me.