Menu
Ask a question Report

Urgent Copy Vertical data from One sheet to another horizontally [Closed]

- - Latest reply: aquarelle
Posts
7241
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
November 22, 2019
 - Oct 9, 2016 at 06:18 AM
Excel Ask a question Report
Hello,

I am trying to copy cell data from one sheet to another, the data in source sheet is vertical and i have to copy horizontally in destination sheet, hence i have to change cell refrence every time. is there any formula we can add.

Data in source sheet :

F11 A
F12 B
F13 C

to be manage in destination sheet :

F11 F12 F13

Thanks!!
K
See more 

1 reply

Report
Posts
7241
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
November 22, 2019
 488
0
Thank you
Hello,

You can use the TRANSPOSE() formula.
Take a look here to learn how to use it.
Regards
Ask a question