Transpose Rows into Columns in Excel

Learn how to transpose rows from only one column into multiple columns in excel using Power Query. Learn to transpose rows into columns in Excel

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

- - - - Blog - - - -

[estephanina]

I've watched several other videos, including yours, while seaching for this solution. I use hstack in excel but had to adjust the formula manually given differing number of "trainings", to borrow from your example. That would have taken me literally 6 hours or more at the rate I was at. I had over 300 "NAMES" tondeal with. You saved my skin!

[mohamedshakir]

Gr8, can u please teach us how to do the opppsite?

[jessievelusamy]

I have 1600+ rows data to be transposed. I tried it now and your tutorial made that a 5-minute job! thanks!

[xtijerina]

I used the techniques in your video for a problem that I was having a difficult time solving. Your video did the trick. Wow!!! THANK YOU SO MUCH!!! I LOVE POWER QUERY!!!

[Graylinepartners]

Fantastic. I came across this on the blog and followed the post. Then, I saw your video. Very clear, exactly what I needed. Thank you, thank you.

[OrdinarySpeaker]

Exactly what I needed, thank you! Very easy to follow and worked like a charm!

[SimX]

I have been looking for this forever, hours on end. Thank you so much for making this video. This is exactly what I needed couldn't find answers anywhere else. Thank you, Thank you and THANK YOU!

[riazarain]

Exactly what I needed, thank you! Very Very much, best wishes for you and your family .thanks

[odoganderson]

AMAZING!!!! You just save me hours of work I could do in 5 minutes with your great power query tutorial - thank you!

[manueldignard]

What a great video!! Thank you so very much!! Saved my skin.

[craftpassion]

Great instructions! easy to follow and it worked

[estephanina]

P.s. to deal w multiple factors to extract, just follow his steps and add a custom column for each data field you need. Worked perctly for me

[vinuthagowda]

This is awesome! Can you teach us how to do the opposite please? “ transform multiple columns while we repeat the same row for a group of columns”

[PilarAnimate]

Wow thank you so much for this helpful and very important tutorial. 😊

[jorgevega]

You are the best! I've been loking for this an entire day.

[ahmedfadali]

Thank you for the valuable videos you give.
I'm importing text files into power query I need to take the first row of each file and put it in a column then fill down to the row of each file. I would really appreciate that.

[chetanparmar]

Thanks you so much, you saved lot of my hours.

[ShubhamSharma-lshj]

Excellent knowledge you have
Thanks for sharing

[thebhaskarjoshi]

AMAZING!!!!
4:54 Another way could be [Trainings][Training]

[darshanshah]

Superb !!! I got what I wanted... Thanks a Lot