Split Data into Separate Rows with Power Query
If you've ever receive an excel file from others or a system that put multiple values into a cells and you needed to have those values split out into separate rows it's not to have if there aren't too many rows or columns to manually do it. But if it is something you need to do on a recurring basis or if it has a LOT of rows or columns, to have it done auto-magically would be nice. You'd might think you'd need to learn VBA to do it, but with Power Query it's pretty easy to do.
0:00 Intro
2:40 Split by comma
11:09 Split by line feed or break
🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p
🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...
📚 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
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF File to Excel
~-~~-~~~-~~-~