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 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!!!
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!
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.
Thanks ... I do have a query ..what if I have a table.of.rows wherein one column is dedicated to payment dates and another column dedicated for payment amounts. A person can have as much as 10 payments in a year, how do I transpose rows to columns such that I have columns named after payment dates and a single row is filled corresponding payments made for specific months without a duplicate for the payee...hope you can propose a solution
@@charie0971 I would say most scenarios are possible in Excel! Most people would find it hard to propose individual solutions without seeing any sample data. However a very good source of information that may help is from a specific Leila Gharani (3 ways to transpose Excel Data) UA-cam presentation found by following this link: ua-cam.com/video/yYVokk0NdiI/v-deo.html There are so many other ideas for a solution available, if you have the time! Just enjoy learning! Best Regards
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?
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.
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
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
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
Check out our newly launched M Language course ↗ - goodly.co.in/learn-m-powerquery/
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!
Gr8, can u please teach us how to do the opppsite?
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!!!
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 easy to follow and worked like a charm!
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.
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!
Glad it helped!
Exactly what I needed, thank you! Very Very much ,best wishes for you and your family .thanks
What a great video!! Thank you so very much!! Saved my skin.
AMAZING!!!! You just save me hours of work I could do in 5 minutes with your great power query tutorial - thank you!
Glad it helped!
You are the best! I've been loking for this an entire day.
Great instructions! easy to follow and it worked
Wow thank you so much for this helpful and very important tutorial. 😊
Thanks you so much, you saved lot of my hours.
Superb !!! I got what I wanted... Thanks a Lot
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.
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
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”
Excellent. Thanks man I’ll use this all the time from now on
Excellent knowledge you have
Thanks for sharing
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.
Thanks Areti! Glad you found it helpful
Absolutely Fabulous. Just what I've been looking for ages. Very Clear, definitely a hit with me. I will Subscribe!
Thanks ... I do have a query ..what if I have a table.of.rows wherein one column is dedicated to payment dates and another column dedicated for payment amounts. A person can have as much as 10 payments in a year, how do I transpose rows to columns such that I have columns named after payment dates and a single row is filled corresponding payments made for specific months without a duplicate for the payee...hope you can propose a solution
@@charie0971 I would say most scenarios are possible in Excel! Most people would find it hard to propose individual solutions without seeing any sample data. However a very good source of information that may help is from a specific Leila Gharani (3 ways to transpose Excel Data) UA-cam presentation found by following this link: ua-cam.com/video/yYVokk0NdiI/v-deo.html
There are so many other ideas for a solution available, if you have the time! Just enjoy learning! Best Regards
@@piersmountford9982 Thank you, I found a workaround while solving for the solution, using transpose and pivoting the columns
Thank you, rare find
Amazing sir!
AMAZING!!!!
4:54 Another way could be [Trainings][Training]
Is it also possible to transpose from columns to rows?
super, thank you!!!
Beautiful..
Nice , thanks for help us
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?
Can you send me a sample of your data? Explain the problem clearly in the email
goodly.wordpress@gmail.com
Excellent Goodly :)
Many thanks!
can i transpose selected columns to rows
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.
how would i do it for multiple columns
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
From the training column, what if we have to extract 2 columns?
yes that's what i'm trying to figure out too
Thanks
helpful thanks
I am getting error :- the column “trainings” of the table wasn’t found. How to resolve it?
how the same work can be done in vba?
that's what i'm looking for
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
C upper case for Table.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
Faced same problem
For me only 20 columns are getting added. What if I have more then 20 records which needs to transpose in to column.
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"
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 am also facing the same issue
Same issue
I keep getting an error when I make the custom column formula. Please help! UGH!
i got that too
On the applied steps, remove changed type before working with the table.
What we have to put after removing changed type
I have to transpose different dates to column
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.