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

Converting A Single Comma Separated Row Into Multiple Rows

65 ratings | 15930 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 (15)
Rubab Mazhar (5 months ago)
this tutorial was a big help in so many ways. Thanks a bunch
Rubab Mazhar (5 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 (5 months ago)
Hi Rubab Mazhar...you're welcome, glad you liked!
Kevin Ronald (10 months ago)
Brilliant!!  thank you Doug
Doug H (10 months 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.