The TOCOL function in Excel is used to convert a range of data into a single column. It helps in organizing scattered data efficiently.
Table of Contents
🔹 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! 🚀
