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.
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).
Note: Only the content is copied, to the format of the destination cells
There is also a command that can achieve this manipulation:
Image: © 123RF.com