splitting one column into multiple columns in google spreadsheet

More info directly from Google: support.google.com/docs/answe...

[@everadept]

Thank you very much. A 1 minute video is still helping 4 yrs later.

[@alsefati8839]

I am so happy you didn't take 5 minutes just braging about who you are, what you do, history of excel...that alone made me subscribe to you ;)

[@GeekyGizmo007]

Is there a way to make "mini-columns" within 1 column? Like... I don't want to split 3 items in column A into A,B,C I want to keep all items within column A and split Column A into 3 "mini-columns"

[@user-ux9fo8dq2k]

Did you get any solution? Facing the same issue

[@user-ux9fo8dq2k]

Hi i got the solution th-cam.com/video/q9LAIdXZNm8/w-d-xo.html

[@philippiansfourseven]

Same here

[@reesearch9773]

is there a solution

[@barbaracarrier]

Thank YOU...concise, clear, and fast...You're my new best friend!

[@MrsPTarleton]

Thank you for the video. Was pleasantly surprised to see you doing this type of video. I generally watch you for inspiration for online business adventures. Thanks again.

[@MeltonECartes]

Excellent tutorial. Concise and clear! Thank you!

[@jackrburns]

Good Job! Short and to the point. I had forgotten how to do this. Thank You

[@polarisendeaversinc2680]

Thank you very much, George! Your tutorial condenses crucial instruction in a short time. very efficient!! i am your new follower!!

[@user-vd6kl1cs6p]

thanks a lot sir i was doing this work from 5 hours but after watching this video i completed my work within seconds

[@francescocicero3055]

Thank you , it really helps me a lot . It was a while that I was searching on youtube this simple function. Thank you and I'll be your new subscriber from Italy

[@user-pm2jl9le7n]

It was really helpful! Thank you Kao! :)

[@snizhanamukomel2286]

Thank you for the tutorial! Fast, simple and easy!

[@kellykimli8528]

OMG you saved me so many hours!!!!! Thank you George!!!!!!!!

[@RoomandBoardReviews]

Super helpful, thanks so much for this. Subscribed because I know the numbers matter.

[@ChiragGehlotforevergreat]

saved my day!
Thank you

[@angelrodriguez3069]

SUPER helpful ! ❤❤ thanks for posting !

[@DMD0612]

Thank you, this was really helpful for me!

[@corinasaturnino8358]

Thank you so much!

[@isaaccontreras5377]

Thanks for the help

[@TomaszMorawski]

Thx 4 sharing - really helpful ;)

[@devibalasureshraina9187]

Thanks its really helpful 😊

[@kellensampson289]

George is the man

[@debatradas1597]

thank you so much

[@deekshithaputta9950]

Thank you soo much

[@pj04laus]

Thank You So Much!

[@christopherogle5163]

George, thanks for the video. Question - how do you automatically split TWO rows of data (from inside one cell) into different columns? What's the custom setting you need to apply in the Separator input? Thanks!

[@SheetsNinja]

You can use a split formula to accomplish this! Let's assume your data is in cell A2, then your formula would look like this:
=split(A2,char(10))
The "char(10)" part is what matches to distinguishing multiple rows of data in a single cell.

[@ashikurrahmanashik2305]

Thank you so much

[@oseanwilliams5022]

thank you!!!

[@supdup4757]

Thak u very much ♥️

[@GradyDonaton12]

What about turning it into rows instead of columns so it goes down?

[@GeorgeKaoCommunity]

Use the "transpose" feature.

[@user-zw5nl1fp3t]

god bless you

[@peterwoods35]

Good!

[@avontjohnson6369]

Let's say I have a list of phone numbers and I want to break them down by 500 a piece. How would I do that?