“Paste link” option–In this method, select the “paste link” option from the “paste special” dialog box. read more” option–In this method, select “paste special” from the context menu and choose “transpose.” The new data table is not linked with the source.Ĥ. There are several ways to paste special in Excel, including right-clicking on the target cell and selecting paste special, or using a shortcut such as CTRL+ALT+V or ALT+E+S. “ Paste special Paste Special Paste special in Excel allows you to paste partial aspects of the data copied.

– INDIRECT Function and ADDRESS functions –In this method, rotate the range with a non-array formula which is “=INDIRECT(ADDRESS(COLUMN(A1),ROW(A1))).” The condition is that the rows and columns begin with cell A1.ģ. Likewise, the number of empty columns must match the rows of the data source. – TRANSPOSE function–In this method, select a blank range containing the exact number of rows as the columns of the original table. The rows and columns of Excel can be transposed in the following ways: How to transpose the rows and columns in Excel? Similar to the book “Biology,” the output for the book “Geography” is listed as follows:Ģ. This is because the number 8 is at the third position. For example, if the range A11:A15 consists of the numbers 2, 9, 8, 14, 32, the formula “MATCH(8,A11:A15,0)” returns 3. Being a lookup and reference function, it works for both an exact and approximate match. The output is the first position found for the given value. This identifies the cell value for which the position is specified by the MATCH function MATCH Function The MATCH function looks for a specific value and returns its relative position in a given range of cells. The curly braces ,0)” returns the position 1. As soon as the CSE key is pressed, the TRANSPOSE formula appears within the curly braces.

The transposed output in D6:I7 is shown in the following image. Press “Ctrl+Shift+Enter” (“Command+Shift+Enter” in Mac).Enter the following TRANSPOSE excel formula in the selected region (shown in the succeeding image).Select the range D6:I7 where the transposed values should appear.The steps to transpose the range A3:B8 are listed as follows:

How to rotate columns in excel