HomeОбразованиеRelated VideosMore From: Doug H

Converting A Single Comma Separated Row Into Multiple Rows

77 ratings | 17914 views
Check out my Blog: http://exceltraining101.blogspot.com This video shows how to convert comma separated row records into multiple rows. There are two examples: (1) A simple solution using paste special transpose and (2) using Power Query to unpivot the comma separated values. The second example would be used in situations where the records could be in the thousands or even millions of records. P.S. Feel free to provide a comment or share it with a friend! #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Html code for embedding videos on your blog
Text Comments (20)
Nyt Pust aps (7 days ago)
this is what i been looking for thank you so much
Nyt Pust aps (5 days ago)
I do have 1 question... I have 2 columns that i want to make into multiple rows. How do I do that?
Doug H (6 days ago)
Hi Nyt Pust aps, glad you liked it, thanks for commenting!
Nathan Doerr (22 days ago)
Saved my life lol Or at least a couple days worth
Doug H (22 days ago)
Thanks Nathan Doerr, glad it helped!
Rubab Mazhar (7 months ago)
this tutorial was a big help in so many ways. Thanks a bunch
Rubab Mazhar (7 months ago)
i am having a problem with your solution in one of my excel files. it give me invalid value error. i have debugged it so many times but i cant seem to find where any invalid values exist. it a simple file. can i share the file with you
Doug H (7 months ago)
Hi Rubab Mazhar...you're welcome, glad you liked!
Kevin Ronald (1 year ago)
Brilliant!!  thank you Doug
Doug H (1 year ago)
Hi Kevin Ronald...you're welcome, glad you liked!
Riki Boy (1 year ago)
Thank you so much for this. It has been a life saver. You're awesome.
Doug H (1 year ago)
You're Welcome!
Kris Johns (1 year ago)
Excellent video. Your helpful step by step explanation was exactly what was needed.
Doug H (1 year ago)
Hi Kris Johns, glad you liked it, thanks for commenting!
TJK (1 year ago)
Thank you for the very useful Excel tip!
Doug H (1 year ago)
You're Welcome!
D. V. (1 year ago)
what if i want to to the opposite? i've got your final table and i want it to look like your initial table? =)
Doug H (1 year ago)
You'd probably looking to do something like this...? https://www.youtube.com/watch?v=W4sK4V9G0GY&t=96s
ExcelIsFun (2 years ago)
Thanks for the splittingly good time!
rockguitarist8907 (2 years ago)
Good lesson.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.