Then, select the exact number of cells as the original range of cells, but in the other direction.įor instance, we have 5 rows and 3 columns, so we need to select 3 rows and 5 columns of cells, for the transposed data. In the following sample spreadsheet, we are going to transpose the table that contains the volume of animal exports by county.įirst, you must know how many rows and columns your original table contains. The syntax for Transpose function is: =Transpose(array) Since it’s an array formula, the function must be entered in a range that has the same number of rows and columns as the source. TRANSPOSE function allows you to switch the orientation of a given cell range (an array) from vertical to horizontal or vice versa. In this article, we will show you how to switch the row value into column value and column value into row value in Excel. In Excel, you can transpose data in two different ways, using the TRANSPOSE function and Paste Special method. In simple terms, the TRANSPOSE function changes rows to columns and columns to rows.

Transposing data in Excel means switching or rotating data from the horizontal array to vertical array, or from vertical array to horizontal array. Learn how to transpose data in Excel and quickly shift the orientation of your columns and rows on a worksheet.

Excel formula to transpose data