Excel - Transposing data from one sheet to another

October 2016


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:

Related :

This document entitled « Excel - Transposing data from one sheet to another » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.