Unpivot Cross Tabulated Data with Multiple Headers and Columns

Подписаться 98 тыс.

Просмотров 31 тыс.

50% 1

Check out our newly launched M Language course ↗️ - goodly.co.in/l...
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....
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/l...
✔️ Power Query Course-
goodly.co.in/l...
✔️ Master Excel Step by Step-
goodly.co.in/l...
✔️ Business Intelligence Dashboards-
goodly.co.in/l...
- - - - Blog - - - -
www.goodly.co....

Опубликовано:

11 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 68

@GoodlyChandeep 11 месяцев назад

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

@Nitinpaste-k5l 6 месяцев назад

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.

@MamoonSharif 3 месяца назад

I was struggling for days and then i came across your video. Thank you for this master piece.

@idowusamuel8992 3 месяца назад

Thank you for this master piece. You just saved the day.

@PuneetKumar-il4bv 6 месяцев назад

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

@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

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

@Guialdelo 4 года назад

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

@GoodlyChandeep 4 года назад

Cheers!

@thebhaskarjoshi 2 года назад

I love your way of teaching.

@GoodlyChandeep 2 года назад

Thank you!!

@himanshuarora837 3 месяца назад

This is the first time I am commenting on a video. If I am complimenting this must be great video. Wishes 🎉🎉

@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

@nicholasbrown7087 3 года назад

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

@m.raedallulu4166 2 года назад

Perfect simplification! Thank you so much!

@AweshBhornya-ExcelforNewbies 5 лет назад

As usual too good. Thanks Chandeep.

@mmincredible1451 4 года назад

Super well explained 👌👍

@subbu_ca 3 года назад

U saved me a ton of time. Thanks bro

@ganzorigsergelen5954 2 года назад

This is the one I have been looking for. Thanks

@HafizAzmi 2 месяца назад

Super Thanks from me, a lot. Very helpful.

@lukev730 5 лет назад

Thank you . Good one

@amoljagdale5626 3 года назад

Very Useful.. Thank you

@cynthiaszczepaniak7050 3 года назад

Very well explained and helpful. Thank you!

@jelulululu 5 месяцев назад

Thanks sir, this helped a lot!

@michaeljones2843 4 года назад

Great example and easy to follow!

@GoodlyChandeep 4 года назад

Glad it was helpful!

@HaiderAli-vt8wn 3 года назад

Simply great

@krishnatate4765 Год назад

Thank you so much sir ☺️🙏

@BiggBrro 10 месяцев назад

Ghazab!

@AlvaroPerez-ox7ul 3 года назад

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

@arfanrasheed9941 11 месяцев назад

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

@gavrielhalberstadt3387 7 месяцев назад

Thank you

@pkjksk 4 года назад

Thanks a lot

@GoodlyChandeep 4 года назад

Happy to help

@olajacekosman9463 4 года назад

U are my hero!!!!!

@GoodlyChandeep 4 года назад

Big words.. thanks :)

@ganeshreddymotakatla6244 5 лет назад

Nice explanation sir...

@1310kumarrakesh 4 года назад

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

@jumpropemonk7703 11 месяцев назад

Can you please share this data set? Many thanks

@iys02189 Год назад

you are fxxx The Genius bro. you are the GOD

@GoodlyChandeep Год назад

Thanks Bro!

@kebincui 3 года назад

super 👍

@ganeshreddymotakatla6244 5 лет назад

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

@eslamfahmy87 Год назад

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

@vaibhavbhosale4750 3 года назад

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

@mikebarrera3233 4 года назад

Damn! Thank you!

@sushantjoshi5865 5 лет назад

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 5 лет назад

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

@sushantjoshi5865 5 лет назад

Ok.. will try.. thanks

@nkowk 4 года назад

👍

@jas-hy3sy 4 года назад

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 ?

@sajadabdulcader5337 2 года назад

Best

@GoodlyChandeep 2 года назад

Thank you!

@jas-hy3sy 4 года назад

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?

@aarthivaratharaj7173 3 года назад

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

@Abecedarianme 4 года назад

Hi! How to do the opposite of this? PIVOTING multiple columns. The goal is the first table seen in your video.

@GoodlyChandeep 4 года назад

Can be done using a pivot table

@SoyLuchoMontero 4 года назад

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

@mon_rich5366 2 года назад

best

@GoodlyChandeep 2 года назад

Thanks

@utfforms6772 3 года назад

how to do this in google sheets?

@kakiraiyan 2 года назад

Is there a way to do this in google sheets?

@GoodlyChandeep 2 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-I3QabLHEuok.html

@jas-hy3sy 4 года назад

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 4 года назад

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 4 года назад

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