Excel - Transposing data from one sheet to another

January 2017


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:


Published by deri58. Latest update on August 18, 2012 at 05:07 AM by deri58.
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 (ccm.net).