Transpose Rows into Columns in Excel 

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

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

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

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!

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

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

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

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!

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

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.

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

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

Great instructions! easy to follow and it worked

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

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

Excellent. Thanks man I’ll use this all the time from now on

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

Excellent knowledge you have Thanks for sharing

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

Thank you, rare find

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

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”

From the training column, what if we have to extract 2 columns?

Absolutely Fabulous. Just what I've been looking for ages. Very Clear, definitely a hit with me. I will Subscribe!

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.

thanks very much- just what i need! I had a macro to do this transpose, but every time I added more rows to the table I have to delete the output and rerun the macro. Your solution is perfect I just need to refresh the query now.

Beautiful..

How to transpose data of sub columns into one columns eg(column day1 -(day readings,night readings).Fit them readings in one columns on the right column.with left column naming whether it is day or night time

Is it also possible to transpose from columns to rows?

super, thank you!!!

Nice , thanks for help us

Amazing sir!

Thanks

helpful thanks

can i transpose selected columns to rows

I am getting error :- the column “trainings” of the table wasn’t found. How to resolve it?

how would i do it for multiple columns

HI SIR THANKS FOR AMAZIG VIDEO, IT HELPS ME MORE, BUT WHEN IT TRIED IN MY SYSTEM, I GOT THE MESSAGE LIKE Expression.Error: The name 'Table.column' wasn't recognized. Make sure it's spelled correctly. Please help me out why this message appearing

that's what i'm looking for

how the same work can be done in vba?

I am having problems doing this for Excel 2016 and in Google Sheets. The Power Query does not seem to be the same and I can't figure out how to do this in the current spreadsheet programs.

I need four columns of data to be connected, (ID, Name, Class Period, and Room Number) transposed from multiple rows into one row per name. I have been doing this for about 2 hours now and it is not compiling into one row per name. What am I doing wrong? @GoodlyChandeep....help.

Hi , My requirement is just the opposite of what you have done. I have a horizontal data with me, which i need to convert to a vertical type for each employee. What i have done manually is i have chosen the columns which i want to be vertical and unpivoted them. I need help in creating a macro for the same,as my columns are dynamic. Can you help me with it?

Excellent Goodly :)

5:20 there is no option for "Extract Values" how do I fix that?

What if the data is numbers and it throws an error mentioning "We couldn't convert to Number"

For me only 20 columns are getting added. What if I have more then 20 records which needs to transpose in to column.

I have been trying for 4 hours to get this to work. I am stuck on where you add a column. I finally got it to add but it doesn't create the 'list'. I used Table.Column([Hotels],"List"). I have added a space before the " to see if that makes a difference, and it doesn't. It gives me an error and it says that the column of List does not exist Except this is the process to add in that column. So the column appears but it says Error all the way down. when I click on the error it stays Expression.Error: The column 'List' of the table wasn't found.. I even tried using the same terminology that you used and nothing. HELP

Anyone know how to do this when the columns are false matches

I m using office 16 but could not find any options at list column. When I am clicking on double arrow it automatically gets expanded. Please help me

I keep getting an error when I make the custom column formula. Please help! UGH!

What i need is the opposite.😢

I m using office 16 but could not find any options at list column. When I am clicking on double arrow it automatically gets expanded.