How To Separate Data Columns wise / text to columns

[@prathameshlagu5733]

Very informative and thanks 👍

[@rohitjain1027z]

Wonderfulll really amazing tric

[@rayleblanc7209]

When I try to split the data in a row, in the text to column window, each row is separated by an empty row. For example in text to column Row 1 cabinet part A data string, Row 2 is empty, Row 3 cabinet part B data string, Row 4 is empty.
So when I OK the split the information is now in every second row and does not line up with the information on the left and extends further down.

[@chiragsomani1571]

Thank You Very Much❤❤❤

[@saifimy9111]

Weldon dear, a very simple method to share with us. ❤🎉

[@Enjoywithpriyanka124]

Thank you so much 🙏 for this

[@sameerv4557]

It saved my lot of time

[@LavanKumar-c8l]

Very helpful Bhai

[@mamafaramokgopa4715]

This is super awesome. Thank you

[@AndresSalazarPhotography]

Just what i was looking for. Thanks a lot

[@antenehanberbir8593]

Thanks you gave us the right solution

[@maxx_in_alaparaigal]

Thank you ❤🎉😊

[@talwindersingh3721]

Thanks

[@pcsonglove098]

thnx

[@VeenaNavi-c7f]

Thankyou

[@yogendrasharma8803]

Thanks Bhai

[@SouthAfricasFuturePresident]

Thank you 🖤

[@techmicrosoft]

Most welcome 😊

[@Manmohak_kahaniya_]

Great👍

[@RupaliMagarde]

Sir agar pdf file ko Excel me jab convert kartey he to kuchh rows ak hi row me mix ho jate he us seprate row me kaise convert kare

[@dineshprasad3262]

Kiya bat hain 😂❤🎉..we need this like more 😢🎉😂❤

[@techmicrosoft]

Thank you 😊

[@itsbrittanywym5356]

Okay now how to do you use this function when they are not all one line but each data set is all on separate rows?

[@usmamd851]

hpw to do in Macbook??

[@shashirs7675]

😮

[@AmiyeshGupta]

Nice

[@prateekagrahari3998]

Bhaishab isko Apply krne ke baad hataye kaise mera deta fir uss tarah ho jaye batiye

[@swathiS-id8rr]

Control kay tell me

[@Dealoftheday26]

Mera data 1 hi coloum me hai or 1 cell me name uske niche number uske niche wale cell me time hai to usko kese alag alag coloum me dale

[@madnessverse8190]

❤

[@Krishna-t5u7t]

Very useful

[@jackeroo75]

Easier to just create a table and then use power query to split the code.

[@zgaming798]

Wow😮

[@kalpeshmeghwal1395]

Itna background ki knowledge dab gyi😂

[@nageshrnaga94]

Thank you 😂

[@McCJA8]

Why is this twice as complicated than what it needs to be

[@Dealoftheday26]

Please help

[@skfirdous9683]

Not working 😢

[@unnatigupta8973]

Not work

[@MIZRAIM1984]

thank you very much! Saved me lots of times! God bless you!

[@entertainers.6642]

thanks