Excel Power Query #10: UnPivot Feature to Create Proper Data Sets (2 Examples)

See how to:
1. (00:08 minute mark) Problem Set up
2. (00:49 minute mark) Use Filter Feature rather than Table Feature to get Table into Power Query
3. (01:30 minute mark) Unpivot Cross Tabulated Table into Proper Data Set
4. (03:12 minute mark) Unpivot Only Two Columns in table to create Proper Data Set.
5. (04:48 minute mark) Sort is different than in Excel.

[excelisfun]

Excel Power Query #10: UnPivot Feature to Create Proper Data Sets (2 Examples)

See how to:
1. (00:08 minute mark) Problem Set up
2. (00:49 minute mark) Use Filter Feature rather than Table Feature to get Table into Power Query
3. (01:30 minute mark) Unpivot Cross Tabulated Table into Proper Data Set
4. (03:12 minute mark) Unpivot Only Two Columns in table to create Proper Data Set.
5. (04:48 minute mark) Sort is different than in Excel.

[qaisarc]

Thank you! I've been using Power Pivot for a while and was convinced it's the best "new" feature in excel but Power Query is simply amazing in helping clean, transform and link to data. Thanks again for the video.

[rorysketch]

Hi Mike,

Currently working through all the vids - my head hurts! :)

All great,

Rory

[excelisfun]

 Bill Szysz  Joe JG  I cannot reply to your comment because of your Google Settings. THE best video made about how to use Power Query to UnPivot complex tables is here:

[Aaseef]

one of the best features and very well explained.

[vgug]

THANKS FOR THE VIDEO, WHAT HAPPEN IF THE DATA ROW IS MORE THEN 1000

[fajnefajne]

Thank you, a nice comment about sorting in PowerQuery.

[ЯнаЯ-пт]

Hi. First, thank you for your videos, its greate job. And I have question: There is data in not wright form from database, to put it in a table form I need to raise sells up in one of the columns. As I understand I cant do it in PQ. Possible, my description is not clear, may I mail you file example (but I dont know your mail). Thank you

[JoeG]

nice video mike. I have to admit I was a little dissappointed with this feature in power query. It seems to work with simple datasets but when it gets complex, this feature doesnt work. Hopefully, microsoft will improve on it. I had a huge dataset with 200 columns that needed to be unpivoted, i ended up writing some ugly SQL code to get it done. 

[JoeG]

Mike, i just sent over a private message, can i send over my sample workbook with the unpivot example. love your channel

[vietnamisfun]

Hi Mike, Thanks again for the video. I am seeking your help on my issue: says I have a column with a number of name indicators, first i replace some names of indicators to "blank" and then try to use "Fill/Down" to fill the "blank" cells. But it doesnt work. I guess because of the "blank cells" is not empty or "null"? is there any solution for this? and is there any way to replace all values in one column to a value except some selected values in Power Query? Thank you so much in advance. look forward to seeing your next videos!