1. Home
  2. EXCEL Forum
  3. How can you transpose data given in a specified column in worksheet 1 in MS Excel into a specified row in worksheet 2?

How can you transpose data given in a specified column in worksheet 1 in MS Excel into a specified row in worksheet 2?
Rajesh Pathak
Here is the solution:
  • Copy the worksheet 1 data, which needs to be transposed.
  • Go to worksheet 2
  • Keep the cursor in the cell of that row where you want data to be transposed.
  • Open paste special using Alt E S
  • Select ‘Transpose’ option
  • Hit enter
  • Data will be pasted horizontally.

    Homepage 
    MS EXCEL TRAINING