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 ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ 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 www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~
Пікірлер: 287
I was stuck with this problem for last 2 weeks, this is super helpful....Thanks Doug🙏
@DougHExcel
3 жыл бұрын
Hi sanchit bhadauria, glad you liked! Feel free to subscribe to my channel as a there are a bunch of these videos and I have new ones published weekly.
Your video shows clealry the real power of PQ !! Thanks Doug !!
@DougHExcel
6 жыл бұрын
Hi Victor Friesen, glad you liked it, thanks for commenting!
Thank you so much for this video, it really helped me few mins ago with my large dataset! You have earned a new subscriber, Dough...
@DougHExcel
4 жыл бұрын
Thanks for the sub!
@SIMRANKAUR-eg7nc
3 жыл бұрын
Please visit channel "off to office" to know everything about text to column at one place and not in bits and pieces in different videos.
It's very helpful. Thank you so much Doug.
@DougHExcel
11 ай бұрын
Thanks neeraja palla, glad it helped!
Thanks @Doug H, saved me a ton of time. I was struggling how to do it with pivots
@DougHExcel
3 жыл бұрын
Glad it helped!
THANK YOU SO MUCH!!!! It truly is so easy to listen to you, this just helped me a ton!
@DougHExcel
2 жыл бұрын
Glad it helped!
Thanks man ... you save hours of work in my team. Following you and ancious to learn more.
@DougHExcel
3 жыл бұрын
Glad to help 👍
It helped me immensely, Thanks a ton!
@DougHExcel
Жыл бұрын
Glad it helped!
Merci merci merci. Thank you so much for your help. I needed this for my work and it's an absolute blessing that you made this video.
@DougHExcel
9 ай бұрын
Glad it was helpful!
Thank you! First video I came to with this question and you answered it perfectly!
@DougHExcel
3 жыл бұрын
Glad it was helpful!
Thanx for this short training. This is what I need today.
@DougHExcel
4 жыл бұрын
Great to hear!
Exactly what I was looking for, thank you for sharing!
@DougHExcel
Жыл бұрын
You're welcome!
This is fantastic and simple to follow you saved the day!!!
@DougHExcel
2 жыл бұрын
Great to hear!
Thank you so much, Your video is so easy to understand and works great!
@DougHExcel
3 жыл бұрын
You're welcome!
YOU ARE A LIFE SAVER MY MAN!!!! Thank you!!!1
@DougHExcel
2 жыл бұрын
You’re welcome!
Thank you for sharing the video on Power Query. Very helpful.
@DougHExcel
3 жыл бұрын
Glad it was helpful!
Thank you! This was so helpful!
@DougHExcel
Жыл бұрын
Glad it was helpful!
Thank you! This was amazing and very easy to follow
@DougHExcel
2 жыл бұрын
You're so welcome!
Thank you Dough! Was very helpful!
@DougHExcel
2 жыл бұрын
Glad it was helpful!
You just saved hours of work. Thank you soooo much!!!
@DougHExcel
3 жыл бұрын
Glad it helped!
Thank you - super helpful and straight to the point. Nice tutorial.
@DougHExcel
8 ай бұрын
Hi peder van roest dahl, you're welcome!
Its simplified my work. Thanks a lot
@DougHExcel
Жыл бұрын
You’re welcome!
This was exactly what I needed. You saved me a lot of time! Thank you very much!
@DougHExcel
4 ай бұрын
You're welcome!
Thanks @Doug H, this video saved me a ton of hassle. Thank you!🌸
@DougHExcel
2 жыл бұрын
Glad it helped!
In need of this ASAP...thank you so much for the help xo
@DougHExcel
2 жыл бұрын
Glad it helped!
Thank you very much. Step by step really helped me
@DougHExcel
Жыл бұрын
You're welcome!
Very useful thank you so much Share with us this classy video
@DougHExcel
6 жыл бұрын
Hi MIS Dev Bartwal, thanks for the comment!
thank you Doug. u saved my day. Awesome
@DougHExcel
4 жыл бұрын
Glad to help
BLESS YOU DOUG! thank you so much!!!
@DougHExcel
Жыл бұрын
You’re welcome!!
Thanks for this. I used the same concept in Power BI. works exactly the same. Never noticed there could be a split by ROWS option whereas the heading of the tool says 'SPLIT BY COLUMN'. Thanks a ton !
@DougHExcel
3 жыл бұрын
You're welcome!
Thank you. You're a lifesaver!
@DougHExcel
3 жыл бұрын
You're welcome!
Thank you so much! My first query and so easy!
@DougHExcel
9 ай бұрын
You're very welcome!
So some and elegant functionality! Thanks for sharing!
@DougHExcel
5 жыл бұрын
Hi lysenkiy, glad you liked it, thanks for commenting!
@lysenkiy
5 жыл бұрын
It was supposed to read 'awesome' lol
Hello, I had spent so many hours today on Google to find this logic and so so happy to finally find your video, super helpful and thanks a ton (have saved it) 😊
@DougHExcel
29 күн бұрын
Glad it helped!
Thank you so much for making my life easier ❤
@DougHExcel
Жыл бұрын
Glad to have helped!
É muito incrível o que esse Power Query pode fazer, obrigado por mais essa aula Doug. Obrigado.
@DougHExcel
6 жыл бұрын
De nada!
Thank you so much for this short video solution..it helped me in my project 🤗
@DougHExcel
2 жыл бұрын
Glad it helped, thanks for the comment!
Bro love to you from india, Really Man you have save my lot of time and i done manually work in just 1 min. Thankyou so much Doug 😉😉😉😁😄
@DougHExcel
Жыл бұрын
Happy to help!😃
This was a HUGE time saver!
@DougHExcel
Жыл бұрын
Glad you thought so!
Super mega helpful! thank you so much, I had no idea this exists!
@DougHExcel
Жыл бұрын
Glad you liked it!
what a life saver, had to do the mandatory subscription, hit the notification and like the video to pay respect.
@DougHExcel
11 ай бұрын
Hi Menjix, thanks for the kind words and the sub!
You're a lifesaver!!
@DougHExcel
2 жыл бұрын
Thanks for watching!
Thank you for sharing this is very helpful! :)
@DougHExcel
3 жыл бұрын
Glad it was helpful!
Thank you a lot for your video saving me at the end moment.
@DougHExcel
Жыл бұрын
You are welcome!
Thanks, that was easy to follow
@DougHExcel
6 ай бұрын
Great to hear!
Super, Thank you very much. You save my day!
@DougHExcel
3 жыл бұрын
Glad I could help!
Thank you for sharing this!
@DougHExcel
3 жыл бұрын
Hi Eleonora Maran, you're welcome!
Thanks for the easy explanation
@DougHExcel
Жыл бұрын
You are welcome!
It helped for me !! thanks 😀
@DougHExcel
2 жыл бұрын
You’re welcome!
Thanks for sharing! Appreciated....
@DougHExcel
2 жыл бұрын
Thanks for the comment!
Thank you Doug H. Very nice explanation and It's really helpful....:-)
@DougHExcel
4 жыл бұрын
Glad it was helpful!
Thank you, helps a lot!!!
@DougHExcel
4 жыл бұрын
Thanks Joao Paulo Dev, glad it helped!
Great explanation thanks 😁👍
@DougHExcel
2 жыл бұрын
My pleasure!
Thanks for your help, It worked Thanks
@DougHExcel
Жыл бұрын
Glad to hear that!
Thankyou for sharing this video
@DougHExcel
8 ай бұрын
My pleasure!
Wow it was that simple!
Thank you for upload this video
@DougHExcel
9 ай бұрын
Hi VTIndia, you're welcome!
What do you do when the source table updates... do you have to manually refresh it every time or will the table update like a formula. If so how do we make it happen automatically like a formula between two sheets would?
Thank you! I love you
@DougHExcel
Жыл бұрын
Hi Nicolás, you're welcome!
Thank you this was easy to follow!!!!!!!!!!!!!!!!!!!!!!!!!!!!1
@DougHExcel
4 жыл бұрын
You’re welcome!
Thank you helped a lot bro
@DougHExcel
2 жыл бұрын
You’re the welcome!
Hi Doug. Thank you for the video and the help. In Power Query, under Advance Options ( 02:40), I have only one option which says 'No. Of column to split into'. It is not showing any Row option. Please help how to get the row option. Thansk.
Save my 5hrs of work because of this. Thanks a lot
@DougHExcel
5 жыл бұрын
Thanks Jessmere Generalao, glad it helped!
Doug u r a life saver..😂😂😂
@DougHExcel
8 ай бұрын
Thanks Hrushikesh Deshpande, glad it helped!
Thank you very much brother
@DougHExcel
3 жыл бұрын
Welcome!
thankyou brother love you
@DougHExcel
3 жыл бұрын
Hi Honey Joyal, you're welcome!
you saved me hour of work
@DougHExcel
2 жыл бұрын
Thanks The Millennial Lifestyle Fix, glad it helped!
Thank you so much...sir😊🍫🙌
@DougHExcel
Жыл бұрын
Always welcome
very useful . thanks
@DougHExcel
11 ай бұрын
You are welcome!
Thank you for this!
@DougHExcel
3 жыл бұрын
You're so welcome!
but it duplicated other values, and all charts i had got messed up and count the values twice for each column i do that for, can we do the trick and we create bar chart which count the items per the unique values
Thank You.❤
@DougHExcel
2 жыл бұрын
You’re welcome!
That was awesome
@DougHExcel
11 ай бұрын
Hi sathish c, thanks for the kind words!
Excellent !!!
@DougHExcel
4 жыл бұрын
Thank you! Cheers!
Thank you sir 😃
@DougHExcel
4 жыл бұрын
You’re welcome!
Excelente... saludos desde Ecuador
@DougHExcel
6 жыл бұрын
Gracias!
Mind blowing!!
@DougHExcel
4 жыл бұрын
PQ is awesome!
AMAZING.. THATS GREAT
@DougHExcel
6 ай бұрын
Hi @SohailAhmad1, thanks for the comment!
Thank you and god bless :)
@DougHExcel
Жыл бұрын
You’re welcome!
I got new ideas, thanks.
@DougHExcel
2 жыл бұрын
You’re welcome!
This is a good one.
@DougHExcel
3 жыл бұрын
Hi Genevieve Pluviose, thanks for the comment!
Hero!❤
Thank you :)
@DougHExcel
3 жыл бұрын
You're welcome!
thank you so much
@DougHExcel
Жыл бұрын
Hi sandun madushan, you're welcome!
thanks, man!
@DougHExcel
4 жыл бұрын
No problem!
Absolutely great
@DougHExcel
3 жыл бұрын
Hi Mihir Hardas, thanks for the comment!
@mihirhardas8297
3 жыл бұрын
@@DougHExcel Hi Dough, you have saved me from staying up at night and figuring this out. Like me many must have benefitted! :)
Great thanks
@DougHExcel
Жыл бұрын
Thanks!
Hi Doug, thank you for the explainer video. I need to do the same in Google sheets and I'm struggling. I have watched your sheets version but it doesn't duplicate the data in row one for every delaminated data entry. Do you have any ideas? 🙏
@angaj
2 жыл бұрын
So what's the workaround? Looking on the same
thank for your reference
@DougHExcel
3 жыл бұрын
Hi one pot dum tea, you're welcome!
Woo hoo! Thank you!
@DougHExcel
3 жыл бұрын
You are so welcome!
Amazing :)
@DougHExcel
4 ай бұрын
Thanks! 😄
Thnx u so mxh sir i got too mxh help from this video again thnx
@DougHExcel
3 жыл бұрын
Always welcome
Thanks 🎉
@DougHExcel
Жыл бұрын
You’re welcome!
Thanks bro
@DougHExcel
7 ай бұрын
Welcome!
Very Good & Simple Sir. But one thing I want to do is. -> I want to Keep Original Row as it is. & Below that, want to Create same variation as you created.
thanks a lot
@DougHExcel
2 жыл бұрын
You’re welcome!
Split column by Delimiter this option not show in my excel 2016.
Is it possible to do thid function in reverse? Essentially I want my end product to be what you had at the beginning.
@DougHExcel
Жыл бұрын
Maybe this one ? kzread.info/dash/bejne/qGtmsrRsn5OfgJs.html
@Doug H Thanks for this video. I have a table which is similar to what you have on the right hand side (i.e. the result you just produced) and I want it in the format you had to your left (with comma separated values). Essentially, I want to to the exact opposite of what you just did here. How do I do that? Thanks
@DougHExcel
3 жыл бұрын
like this? kzread.info/dash/bejne/iWinrZaPaaqWd7w.html
@mbusoharvey2447
3 жыл бұрын
@@DougHExcel Thanks. But what if you have two columns for example column 1 contains Invoice_ID and column 2 contains product_ID? And I want all products under one invoice to be in the same row as the invoice_ID and separated by commas. Is that possible? Literally reverse engineering what you just did on this particular video. Thanks
thank you
@DougHExcel
Жыл бұрын
You’re welcome!!!