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.
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.
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:
This document, titled « Excel - Transposing data from one sheet to another », is available under the Creative Commons
license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM