The best thing with using TRANSPOSE function is that if you change the values in the source range then transposed range will also change accordingly. TANGO! Your data is transposed! Benefit of TRANSPOSE Function Yes! Not just Enter key but Ctrl+Shift+Enter as this is an array formula Step 4: Write TRANSPOSE function following the equal sign and enter the data range that you want to transpose Step 3: Press F2 key to enter edit mode while the region still selected. Step 2: Select a vacant region in the worksheet which is 2 rows deep and 7 columns wide. Step 1: Determine the rows and columns of data. In our case it is 7 rows and 2 columns Once you transpose the data it will be 2 rows and 7 columns. For example you have 2 columns and 7 rows. IMPORTANT: Determine the rows and columns of your data. The use of this function is a little tricky and requires knowing more than pressing TAB so follow the steps closely. Yes there is a function that can do the somersault called TRANSPOSE. Told ya! it is easy! Method 2: TRANSPOSE Function to switch columns to rows or vice versa This will open the paste special dialogue from which check the transpose checkbox and click OK button

under paste sub-group click transpose button that comes with this icon OR.

And go to Home tab > clip board group > click the drop down button just under paste button > select: Step 2: Go to the cell where you want the data to paste. Step 1: Select the data that you want to transpose and copy it using the copy button or with Ctrl+C shortcut.

flipping columns to rows or rows to columns.

In Excel you can copy a data and then using paste special functionality you can twist, rotate, manipulate, process and do other things with the data very easily including Transpose i.e. With Paste Special it really went miles ahead. Method 1: Convert columns to rows using Paste SpecialĬopying and Pasting is one great thing happened to PC.

How to copy and transpose in excel