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

Converting A Single Comma Separated Row Into Multiple Rows

83 ratings | 19668 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 (21)
dkumar50 (27 days ago)
How can I get a hold of your sample files that you work with?
Nyt Pust aps (2 months ago)
this is what i been looking for thank you so much
Nyt Pust aps (2 months 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 (2 months ago)
Hi Nyt Pust aps, glad you liked it, thanks for commenting!
Nathan Doerr (2 months ago)
Saved my life lol Or at least a couple days worth
Doug H (2 months ago)
Thanks Nathan Doerr, glad it helped!
Rubab Mazhar (9 months ago)
this tutorial was a big help in so many ways. Thanks a bunch
Rubab Mazhar (9 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 (9 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.