Split Comma Separated Values or Delimited Data into Separate Rows
Have you ever gotten a spreadsheet from someone or a system where it had one column essentially have a list of items that were separated by commas (or maybe semicolons), but it was tied to the value of another column? Maybe it was a list of items that were sold but was tied to one invoice or sales number. It would be nice to separate out the comma separated list and still tie it to the invoice number. By using Power Query, this can be done in a few easy steps. See how with this video!
🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p
🏫 Excel Training ➜ https://www.exceltraining101.com/p/training.html
📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101
📝 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 https://www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
Видео Split Comma Separated Values or Delimited Data into Separate Rows канала Doug H
🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p
🏫 Excel Training ➜ https://www.exceltraining101.com/p/training.html
📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101
📝 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 https://www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
Видео Split Comma Separated Values or Delimited Data into Separate Rows канала Doug H
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Separate Data from One Column to Multiple Columns - LIFE SAVING EXCEL TRICK!](https://i.ytimg.com/vi/LKx9QsCXDLY/default.jpg)
![](https://i.ytimg.com/vi/YpLopHF3oJQ/default.jpg)
![How to Split Data Into Different Columns (Comma Delimited txt File to Microsoft Excel)](https://i.ytimg.com/vi/3tCkzCMqopM/default.jpg)
![3 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa)](https://i.ytimg.com/vi/yYVokk0NdiI/default.jpg)
![combine multiple cells value in a single cell using comma, space in #Excel](https://i.ytimg.com/vi/YNmeqns588I/default.jpg)
![Google Sheets Tips and Tricks - Comma Separated List - Analyze Data](https://i.ytimg.com/vi/Sq0f8Z9qE7k/default.jpg)
![Convert Excel Column to comma separated values](https://i.ytimg.com/vi/9X_AooHUSGA/default.jpg)
![How to Extract Part of Text String from an Excel Cell](https://i.ytimg.com/vi/1h1ceAL5rLk/default.jpg)
![How to split text in excel - 7 methods](https://i.ytimg.com/vi/y4KSW50YoW8/default.jpg)
![How to Split Multiple Lines in a Cell into a Separate Cells/Columns](https://i.ytimg.com/vi/oY__ydhIToA/default.jpg)
![Google Sheets: Intermediate - Split Text to Columns](https://i.ytimg.com/vi/MT7j1kACs-8/default.jpg)
![How to convert vertical data into horizontal data separated by comma | Convert column to row](https://i.ytimg.com/vi/fvIpdQc-XhA/default.jpg)
![Created a Comma Separated Value List from a One Column Table or List](https://i.ytimg.com/vi/QKRSF7TM88M/default.jpg)
![Split Multiple Lines in a Cell into Separate Cells - Rows or Columns. Text to Columns & Power Query](https://i.ytimg.com/vi/XcZY_SLgUUU/default.jpg)
![Split Multiple Lines into Separate Rows with Excel Power Query](https://i.ytimg.com/vi/wJ6y2anloW4/default.jpg)
![How to Remove Comma in Excel (from Numbers and Text Strings)](https://i.ytimg.com/vi/5AQYOm0EVzE/default.jpg)
![Converting A Single Comma Separated Row Into Multiple Rows](https://i.ytimg.com/vi/0zK7urGKg_Q/default.jpg)
![Quickly Concatenate Multiple Cells - Combine Cells with commas, space and semicolon - YouTube](https://i.ytimg.com/vi/sISgnSMKttA/default.jpg)
![EXCEL | Split, Comma Separated values into Separate ROWS in Excel - In Hindi](https://i.ytimg.com/vi/FmuscJqvR0g/default.jpg)
![Excel Formula to Split data into Rows and Columns [Split Function]](https://i.ytimg.com/vi/UlWabNg0G74/default.jpg)