Read this short guide if you would like to transfer data between two Excel spreadsheets. We will show you how to bind data from a column to a row in another sheet.
How to transfer data between two Excel spreadsheets?
Consider that the data to be copied are on Sheet1! B2:H2 and and the targeted ones in Sheet2! C3:C9 (the number of cells are identical).
- Select the second range (Sheet2)
- Type = TRANSPOSE =TRANSPOSE(Sheet1!B2:H2)
- Confirm with CTRL + SHIFT + ENTER to obtain an array formula.
Note: Only the content is copied, to the format of the destination cells
How to transfer data on Excel via a command?
There is also a command that can achieve this manipulation:
- Copy/Paste > Paste Special > Transpose.