Excel Pro Trick: Combine Merge Multiple Columns into One Column with
In Excel we deliberately divide data in several columns. This way its easy to process as each column is about one aspect of data. But some situations demand to combine all the columns into one column in Excel. This is where it gets tricky!
In Excel, there was no straight forward method to do it, until we got TOCOL function.
With TOCOL function we can easily combine stack multiple columns into a single column in seconds without writing any complex Excel formula. This one Excel function is enough to combine multiple columns in a single column.
Excel TOCOL function can scan columns row-by-row or column-by-column and depending on the situation we can select the scan pattern.
In this Excel tutorial video we will learn how to use TOCOL function to combine multiple columns into one column.
Lets Excel!
Access or Download Practice Workbook for this Excel Tutorial:
1drv.ms/x/s!Apno7889bCyLrUI1p...
For more Excel tips, tricks and tutorials don't forget to subscribe to @LearnExceltoexcel YT channel.
Learn #Excel your way:
===================
Website: learnexceltoexcel.com/
--------------------------------------
Pick your favourite social page:
Fb: bit.ly/3yM3dvd
Tiktok: bit.ly/3wFllpf
Tw: bit.ly/3wGCRYU
Pin: bit.ly/3NsjKIU
Yt: bit.ly/3wxKL8a
Insta: bit.ly/3wtT9oW
Music by: / ikson
#exceltocol #tocolfunction #exceltutorial #exceltips
Пікірлер: 44
You would not believe how many videos I had to check before I found yours. This is exactly what "MERGE TWO COLUMNS IN ONE" means. I will be checking out your site to subscribe. Thank you so much.
@LearnExceltoexcel
7 ай бұрын
Glad it helped!
i cannot thank you enough! you saved me after so many failed attempts with chatgpts weird formulas! you are amazing!
Exactly what i needed for something that would've rather taken hours, thanks a lot
like👍748 TOCOL great to know😊 thanks🤩
Thanks, I spent so much time looking for this and it was so easy, you are a real lifesaver
What a time saver thank you, keep up the good work!!!
Amazing!!!! Thank you!
I don’t get tocol formula in 2019 excel version of offline. How can I get it in 2019? Is it support offline? Or have any alternative to it?
Thanks so much!
Thanks 🙏🏼
thanks a lot
Love you man
Please teach the old version. 2016. How to use it??
Thanks i am finding the solution from morning
thank you so much you saved my life
@LearnExceltoexcel
7 ай бұрын
Happy to help
thank you so much m(_ _)m
I fucking love this thank you man 1000x times
This works only in Excel 365 right?
Nice short and sweet video. But you ignored the IGNORE argument. For me, it was extremely helpful to have it ignore blanks.
If we want transfere from one column to columns & row 3X4.. how ?
what about text instead of number for example two rows 1 A space 2 B space second row a b i want the second row merge into one like 1 A a space 2 B b space how to do it ?
Reverse is needed
Not working for me
Thank you.. Will it work in google sheet?
@LearnExceltoexcel
Жыл бұрын
You can try uploading this Excel file and see if it works in Google sheets. Most of the formulas in Excel and Google sheets are ditto same.
How to work on Excel 2007
Tocol not available for me
About 80% of people have old type version. And dear you have latest version. Otherwise your teaching method is awsome
@LearnExceltoexcel
Жыл бұрын
Yes! Its still taking time to get to every Excel version. But happy that at least we have solution in sight :)
@LearnExceltoexcel
Жыл бұрын
Btw appreciate your kind words. Glad you found the method effective. stay blessed
@LearnExceltoexcel
Жыл бұрын
Just uploaded a new video on how to combine columns into one with power Query that is available to everyone
@sagardeokar6537
Жыл бұрын
@@LearnExceltoexcel Can you share link
TOCOL FUNCTION IS NOT WORKING
#NAME us the result getting.. Why?
Not working...
Not working
@happyfamily6676
Жыл бұрын
I add formula and press enter key, show # name?
@happyfamily6676
Жыл бұрын
Ok
It's not working
@LearnExceltoexcel
Жыл бұрын
What error are you getting and which version of Excel do you have?
@LearnExceltoexcel
9 ай бұрын
Hahaha emojis are WILD!