Excel Tricks: Split Comma-Separated Values into Rows Easily!

Welcome to your ultimate guide on Excel tricks, where today we're tackling a common but perplexing challenge: splitting a single comma-separated row into multiple rows effortlessly. Whether you're managing data for business analysis, school projects, or personal tasks, Excel is a powerful tool that can make your life easier. In this video, we'll show how to convert comma separated (delimited) row records into multiple rows. Think of it as splitting a csv column into multiple rows. There are two examples: (1) A simple solution using paste special transpose on the comma list values and (2) using Power Query to unpivot the comma separated values. The second example would be used in situations where these multiple records could be in the thousands or even millions of records.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[jdbhouston]

I must add another note of thanks - I keep coming back to this video maybe once a year when I get another file that needs to be formatted. Thanks!

[jujubean]

The only you tuber that actually answered my question. You are amazing!

[haimcm]

AWESOME. This video saved me hours of work. It clearly describes how to resolve the problem Massive Thank You.

[Venezuelangel]

What?!?! Computer tutorials without an incomprehensible Indian accent?!?!!? This must be witchcraft and I must subscribe to it!

[mercmichigan]

Excellent video. Your helpful step by step explanation was exactly what was needed.

[rubbyz]

this tutorial was a big help in so many ways. Thanks a bunch

[jdbhouston]

Thanks for the video and the very clear explanation!

[tjk]

Thank you for the very useful Excel tip!

[nytpustaps]

this is what i been looking for thank you so much

[robedwards]

Hey Doug, how do I separate a single strand of data from notepad into a vertical column? For example rob, joe, emily, ryan, etc... It's a copy and paste, then it shows up in a single A cell. I just don't know how to separate it.

[pgwidjaja]

At the end of row of my comma seperated value. It has a semicolon to indicate new row. How to make excel recognize this?

[NathanDoerrRealtorDoerr]

Saved my life lol Or at least a couple days worth

[ciciainthesky]

So I have an Excel file filled with MANY colums of data that is only on one row. The problem is it's not in the correct format. The row has a pattern of:

"surname" "name" "email" "surname" "name" "email"
I will need to unpivot it this way:

ROW A: "surname" "name" "email" ROW B: "surname" "name" "email"

with each person on one single row, not an endless row with all the data.
I need the row to break after the semicolon (as some names are broken down into more than two columns).

I was wondering if there is a way to do this in Excel, without having to do it manually. It is truly taking forever and it's not viable.

Thank you very much in advance for your help.

[maipensapparot]

what if i want to to the opposite? i've got your final table and i want it to look like your initial table? =)

[dkumar]

How can I get a hold of your sample files that you work with?

[mirshovkat]

Can u split a single cell to have multiple rows of data