After that, pick the Pivot Table option.In the first place, select the whole table.In this method, I will use the Pivot Table to Transpose the data. Method 3: Use Pivot Table to Transpose a Table in Excel How to Reverse Transpose in Excel (3 Simple Methods).Transpose Multiple Columns into One Column in Excel (3 Handy Methods).How to Convert Columns to Rows in Excel (2 Methods).How to Transpose Duplicate Rows to Columns in Excel (4 Ways).

Read More: How to Transpose Array in Excel (3 Simple Ways) Here we shall do it with the Transpose function. Using a function is one of the easiest methods to perform a task in Excel. Method 2: Insert TRANSPOSE Function to Switch Table in Excel Read more: Excel Paste Transpose Shortcut: 4 Easy Ways to Use Now, see the table has been transposed to the new location.Press Ctrl + Alt + V, and the Paste Special box will pop up.Secondly, activate a new cell where you will transpose the table.Press Ctrl + C, a dancing rectangle will appear at the border of the selected range of cells.Firstly, select the whole table using a mouse.In the following table, I have used 4 columns with the headers of Product, Price, Quantity, and Total and 6 rows with the headers of some fruits names.īy using the Paste Special option here, I’ll transpose the table which means the rows and columns will be exchanged. Let’s get introduced to the dataset first. 5 Suitable Methods to Transpose a Table in Excel Method 1: Use Paste Special Tool to Transpose Table in Excel

Transpose button in excel does what