Home>Blogs>Excel Tips and Tricks>Quick Merge Multiple Columns using TOCOL Function
Combine Multiple columns Data
Excel Tips and Tricks

Quick Merge Multiple Columns using TOCOL Function

Are you struggling with organizing vast amounts of data across multiple columns in Excel? Look no further! Our latest YouTube video, “Quick Merge Multiple Columns using TOCOL Function!” offers a straightforward solution.  Let’s dive into the seamless process of combining data from multiple columns into a single one, enhancing your data management skills!

Understanding the Scenario

Imagine you’re working with a dataset representing various departments, such as IT, HR, Sales, MIS, Procurement, and Transport. These departments are spread across Columns D to I. Your task is to consolidate all the employee data from these departments into Column A. This might sound daunting, but it’s quite simple with the right tools.

Employees for different departments
Employees for different departments

The Magic of TOCOL Function

The TOCOL function is our hero in this scenario. This function is designed to effortlessly merge data from multiple columns into one. We applied the TOCOL function in our example using the range A2, with the formula “=TOCOL(D2:I15,1).” The result? All employee data from the specified departments neatly compiled into Column A.

TOCOL Function
TOCOL Function

Step-by-Step Guide to Implementing TOCOL

  • Identify Your Data Range: In our case, it’s Columns D to I, covering the departmental data.
  • Select the Destination Column: For us, it’s Column A, where we want all the combined data to appear.
  • Apply the TOCOL Formula: Click on cell A2 and type “=TOCOL(D2:I15,1)“. This formula instructs Excel to pull data from Columns D through I and merge it into Column A.
  • Execute and Observe: Press Enter and watch as the data from multiple columns merges into one, providing a streamlined view of all employee information.

Why Use TOCOL?

  • Simplicity: The TOCOL function simplifies data management, especially when dealing with large datasets.
  • Efficiency: It saves time and effort by eliminating the need for manual data consolidation.
  • Accuracy: Reduces the risk of errors that can occur with manual data entry or copying and pasting.


Merging multiple columns into one doesn’t have to be a tedious task. With the TOCOL function, you can do it quickly and accurately, saving time and reducing errors. We hope this blog post has made the process clear and easy to understand. If you found this helpful, don’t forget to check out our YouTube video for a visual guide!

Remember, managing data efficiently is key to success in any business or project. Embrace these tools and techniques to enhance your productivity and data management skills. Happy merging!

Visit our YouTube channel to learn step-by-step video tutorials


Watch the step-by-step video tutorial:

Click here to download the practice file

Meet PK, the founder of PK-AnExcelExpert.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your Excel skills to the next level!