Tag: Data Reshaping in Excel

How to Use TOCOL and TOROW Functions in Excel (With Examples)

Jun 27, 2025

—

by

Himanshu

in Excel Training

Excel 365 and Excel 2021 introduce powerful dynamic array functions like TOCOL and TOROW, which help you reshape arrays into a single column or row effortlessly. Let’s explore how they work and when to use them. 🔷 1. TOCOL Function – Convert to Column 📌 Purpose: TOCOL transforms a 2D array or table into a…