How to Use TOCOL Function in Excel | Convert Data to a Single Column

The TOCOL function in Excel is used to convert a range of data into a single column. It helps in organizing scattered data efficiently.

🔹 Example: Converting Employee List into a Single Column

📌 We Have the Following Employee Data:

Customer Service	Marketing	Sales	Accounting
Aarav	Aniket	Pooja	Priya
Rajesh	Suraj	Aishwarya	Ananaya
Vikram	Kunla	Ritu	Kavya
Sandeep	Manish	Sangeeta	Sneha
Rohan		Neha	Meera
			Pooja

📌 Formula to Convert This Data into a Single Column:

=TOCOL(A4:D9,1)

🔹 Explanation:

• A4:D9 → The range of data to be converted.
  
• 1 → Ignore blank cells and convert the data into a single column.
  

✅ Now, Excel will list all employee names in a single vertical column! 🚀

Example: