Excel - Transposing data from one sheet to another
April 2018
Issue
Does someone can tell me how to make transpose data between two Excel sheets?
I want to bind data: from a column to a row in another sheet.
Solution
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 identical).
- Select the second range (Sheet2)
- Type = TRANSPOSE =TRANSPOSE(Sheet1!B2:H2)
- Confirm with CTRL + SHIFT + ENTER to obtain an array formula.
Notes
Only the content is copied, to the format of the destination cells
Using an Excel command
There is a command that can achieve this manipulation:
- Copy/Paste > Paste Special > Transpose.
- Please refer to this FAQ Excel - Convert a row into a column and vice-versa
Related
- Excel - Transposing data from one sheet to another
- Excel match data from 2 sheets » How-To - Excel
- Transfer Data Between Excel Spreadsheets » How-To - Excel
- Excel - Copy data from one sheet to another » How-To - Excel
- Excel - Transfer data between several sheets » How-To - Excel
- Excel - Read data from another sheet » How-To - Excel