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.


🔔 SUBSCRIBE to my channel ➜ [ Ссылка ]

🏫 Excel Training ➜ [ Ссылка ]...

📚 Excel Books & Tech Gear ➜ [ Ссылка ]

⚙️ Tools: Screencasting ➜ [ Ссылка ]

⚙️ Tools: Microsoft Office ➜ [ Ссылка ]

⚙️ Tools: TubeBuddy ➜ [ Ссылка ]

📝 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!

🎁 If you find these videos useful and want to support my channel go to [ Ссылка ]

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
[ Ссылка ]
-~-~~-~~~-~~-~-

свернуть