➤ Write the serial numbers from 0 to the total row number-1 or 6-1 or 5 (as here total row is 6) to the top of the area where we will paste the data and use the serial numbers from 0 to the total column number-1 or 2-1 or 1 (as here total column is 2) to the left of the designated area.Īfter giving input the serial numbers, now we will move to the use of the OFFSET function with these numbers. In this section, we will use the OFFSET function to paste the following dataset as a link and convert the rows into columns. Method-2: Using OFFSET Function to Paste Link and Transpose

Read More: Exchange (Copy, Import, Export) Data Between Excel and Access Using any other versions except for the Microsoft Excel 365 version you have to press CTRL+SHIFT+ENTER instead of pressing ENTER for using the TRANSPOSE function. TRANSPOSE will convert the vertical range B3:C8 to the horizontal range.įinally, you will be able to paste the dataset as a link and transpose it like the following figure. Now, it’s time to paste the values as links by using the following formula Then, we will get the following transposed formats of the dataset.

➤ Click on the Formats option and the Transpose option and then press OK. ➤ Select the cell where you want to paste the values and then open the Paste Special dialog box by pressing ALT, E, S one by one.Īs we are pasting the formats only now by transposing them, Here, we will use the TRANSPOSE function to copy the following dataset and then Paste Link with Transpose feature simultaneously. Method-1: Using TRANSPOSE Function to Paste Link and Transpose in Excel We have used Microsoft Excel 365 version here, you can use any other versions according to your convenience. Here, we will use the following table to do these combinations using different ways. 8 Ways to Paste Link and Transpose in Excelīy using Paste Link you can copy the reference to the main source instead of copying only values so that for further alteration of any value the pasted values will be changed automatically and by using the Transpose option you can paste your data with a 90-degree rotation that means rows become columns and columns become rows.

How to copy and transpose in excel