convert multiple columns to rows in excel

How to use TOCOL function in Excel - formula examples The result is placed in cell E2, from which it spills into the below cells. Please notice the semicolon-separated rows and comma-delimited columns: Technically, the range A2:C5 is first converted into a two-dimensional array. In terms of Excel, the result is called a spill range. The formula is entered only in one cell (E2 in this example) and spills into the below cells automatically. For example, to place a two-dimensional array consisting of 3 columns and 4 rows into a single column, the formula is: The TOCOL formula in its simplest form requires just one argument - array. TOCOL is a new function, which is supported in Excel for Microsoft 365 (for Windows and Mac) and Excel for the web.īasic TOCOL formula to transform range into column change rows to columns, utilize the TRANSPOSE function. To transpose an array from horizontal to vertical or vice versa, i.e.To do the opposite column-to-array transformation, use either the WRAPCOLS function to wrap by column or the WRAPROWS function to wrap by row.To convert an array into a single row, use the TOROW function.

Convert multiple columns to rows in excel