Unpivot Cross Tabulated Data with Multiple Headers and Columns

Рет қаралды 25,196

4 жыл бұрын

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

Пікірлер: 65

@GoodlyChandeep 7 ай бұрын

Check out our newly launched M Language course ↗ - goodly.co.in/learn-m-powerquery/

@_KING_SHADOW Ай бұрын

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.

@PuneetKumar-il4bv Ай бұрын

wow man you nailed it spot on. we just did for 3 headers. A big salute from Canada....!!!

@Guialdelo 4 жыл бұрын

I was just looking for this exact thing. Thanks bro! You're a legend!

@GoodlyChandeep 4 жыл бұрын

Cheers!

@jellalfernandez8106 21 күн бұрын

Thanks sir, this helped a lot!

@AweshBhornya-ExcelforNewbies 4 жыл бұрын

As usual too good. Thanks Chandeep.

@mmincredible1451 4 жыл бұрын

Super well explained 👌👍

@m.raedallulu4166 2 жыл бұрын

Perfect simplification! Thank you so much!

@cynthiaszczepaniak7050 3 жыл бұрын

Very well explained and helpful. Thank you!

@nicholasbrown7087 2 жыл бұрын

This was easy to follow and helped me get my task accomplished! Thanks!

@christophertauss3640 Жыл бұрын

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.

@ganzorigsergelen5954 2 жыл бұрын

This is the one I have been looking for. Thanks

@amoljagdale5626 2 жыл бұрын

Very Useful.. Thank you

@lukev730 4 жыл бұрын

Thank you . Good one

@thebhaskarjoshi 2 жыл бұрын

I love your way of teaching.

@GoodlyChandeep 2 жыл бұрын

Thank you!!

@subbu_ca 2 жыл бұрын

U saved me a ton of time. Thanks bro

@AlvaroPerez-ox7ul 2 жыл бұрын

Great vid thanks! What one can do if Seg 4 columns would be text?

@gavrielhalberstadt3387 3 ай бұрын

Thank you

@ganeshreddymotakatla6244 4 жыл бұрын

Nice explanation sir...

@Smoestar87 3 жыл бұрын

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

@GoodlyChandeep 3 жыл бұрын

Glad I could help! Cheers

@krishnatate4765 9 ай бұрын

Thank you so much sir ☺️🙏

@HaiderAli-vt8wn 3 жыл бұрын

Simply great

@michaeljones2843 4 жыл бұрын

Great example and easy to follow!

@GoodlyChandeep 4 жыл бұрын

Glad it was helpful!

@sabarashid1513 2 жыл бұрын

Hi Chandeep, can't thank you enough for sharing these business cases. They actually save the day for people like me. Looking forward to all of your videos that helps us in day to day issues.

@GoodlyChandeep 2 жыл бұрын

Glad to hear that

@mikebarrera3233 3 жыл бұрын

Damn! Thank you!

@arfanrasheed9941 7 ай бұрын

Thats awesome, but what if we have three headers?? In my case there is department name then attendance type, then total count of attendance hence 3 headings

@pkjksk 3 жыл бұрын

Thanks a lot

@GoodlyChandeep 3 жыл бұрын

Happy to help

@jumpropemonk7703 7 ай бұрын

Can you please share this data set? Many thanks

@tarekgalal654 Жыл бұрын

Genius 👌

@1310kumarrakesh 3 жыл бұрын

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...

@BiggBrro 5 ай бұрын

Ghazab!

@iys02189 Жыл бұрын

you are fxxx The Genius bro. you are the GOD

@GoodlyChandeep Жыл бұрын

Thanks Bro!

@kebincui 2 жыл бұрын

super 👍

@vaibhavbhosale4750 2 жыл бұрын

Hi it is useful to me but i want to convert that final segment single row into multiple Rows as segmwnt 1 segment 2 can you suggest something

@olajacekosman9463 4 жыл бұрын

U are my hero!!!!!

@GoodlyChandeep 4 жыл бұрын

Big words.. thanks :)

@eslamfahmy87 8 ай бұрын

If we need the data like Excel without un piovet. Can we do like that. As, I need to keep the 2 headers as excel

@ganeshreddymotakatla6244 4 жыл бұрын

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.....

@jas-hy3sy 3 жыл бұрын

I can't seem to get it with this data: info.worldbank.org/governance/wgi/, I want countrycode, country, and year to be rows, and the values for all the variables to be columns. Could you help?

@jas-hy3sy 3 жыл бұрын

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 ?

@SoyLuchoMontero 3 жыл бұрын

After I transpose the table, it says "Table is empty". Any way to solve this?

@aarthivaratharaj7173 2 жыл бұрын

How to create cross tabulated data with multiple headers and columns using pandas in python.Thanks in advance

@sajadabdulcader5337 Жыл бұрын

Best

@GoodlyChandeep Жыл бұрын

Thank you!

@nkowk 3 жыл бұрын

👍

@sushantjoshi5865 4 жыл бұрын

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?

@GoodlyChandeep 4 жыл бұрын

You can directly link the excel workbook into Power Query, that makes it refresh-able. Creating a table is not necessary

@sushantjoshi5865 4 жыл бұрын

Ok.. will try.. thanks

@utfforms6772 3 жыл бұрын

how to do this in google sheets?

@jas-hy3sy 3 жыл бұрын

Basically, I want every column to have non repetitive values except for 2 (which is usually the case with panel data, e.g. country and a range of years repeat). how would I do that?

@GoodlyChandeep 3 жыл бұрын

Jas, I need to see the data to be able to let you know the solution. Can you share a snippet of the data and how do you want it transformed on my email - goodly.wordpress@gmail.com

@jas-hy3sy 3 жыл бұрын

@@GoodlyChandeep Wow thank you for the kind help. I actually took it from the power query and created a pivot table from it, and then set up the rows and columns as I liked so that got the job done. If you'd still like to view the data, it is: info.worldbank.org/governance/wgi/ It's the Excel file. Thank you for the out reach :) Your video really really helped me, I was so lost.