Microsoft Excel Power Query Pivot Column

Microsoft Excel offers a Powerful feature called Power Query that will allow you to quickly transform unusable data into an organized list.

Visit the link below to download the exercise file and follow along.

[jonslinn]

Thank you so much for this vid, I lost a morning trying to figure this out before finding the vid!

[Mandelbrot]

I think this video will become very popular, it solves a common problem in an excellent manner.

[boneson]

This is supremely helpful feature of the excel, something that I have been waiting for. My thanks to Kyle for explaining it to us.

[ExcelwithAG]

I did try and it worked wonderfully well, I was using modulo column and then filling up and removing the nulls but there was an issue. Imagine in the real world all the cells are not filled all the time and fill up was filling all the way up and information was getting messed up, but integer division just takes that out of preposition. Great solution

[sriharim]

mind blowing... wonderful solution... thanks for sharing

[Karthickchidambaram]

👌👌 I use countif offset and match function together to clean this type of data. Power query is very simple and powerful

[resoundingprosperity]

Thanks a lot Kyle, i would definitely practice. you are the best

[Obaidzz]

Thank you Kyle, you make me your fan indeed

[spring]

Hi Kyle, Thank you so much for your video. I have a question for you, if the data is not following any pattern, some have phone number or email address and some doesn't. If I do this step then the data messed-up. How to solve this problem?

[elizenolte]

This is very helpful. My challenge is that I get reports imported from external source and dumps the data all in one row. It also repeats, Q1& average, Q2 & average, etc for the year. Can Power Query help?? I have always just copied and paste it, but maybe there is a better way.

[martins]

I can't see how this would work in the real world. ie Some records have two lines, some have three, four, five or six. How would you avoid a huge amount of manual editing to conform the data?

[austinliu]

Is it possible to write a macro that can do the power query Pivot Column?

[cynthiaszczepaniak]

This is very, very helpful information. Question: The "don't aggregate" option does not appear in the advanced options when pivoting, why?

[nirmalkhalsa]

Hi Kyle, I am in the middle of doing your Excel course and I received an email linking to this lecture. As I noticed before the Power Pivot function is not built into the Mac version of Excel. Is it the same with the Power Query feature? Thank you again your course has taught me a lot!!

[djcliff]

Thanks for the video. I hope you can help me with a similar one. Now in your column the name, phone, address is in order. lets say the second column the address, name, phone, email is included. let's say the data is mixed up. I hope you understand the question. Hope you can help with this.

[SampathKumargv]

Can we do this by using special copy paste function?