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

Question

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

Report

k - Oct 5, 2016 at 01:57 AM
aquarelle

Posts: 7084
Registration date: Saturday April 7, 2007
Status: Moderator
Last seen: September 25, 2020

- Oct 9, 2016 at 06:18 AM

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

Urgent Copy Vertical data from One sheet to another horizontally
How to copy data from one sheet to another in excel using formula - How-To - Excel
Automatically transfer data from one sheet to another in excel - How-To - Excel
How To Copy Data from One Excel Sheet to Another Using a Formula - How-To - Excel
How to automatically transfer & save data from one sheet to another in excel ✓ - Forum - Excel
Excel copy data from one sheet to another ✓ - Forum - Excel

1 reply

Ask a question

aquarelle · Answer 1 · 2016-10-09T06:18:13-0400

Answer 1 / 1

aquarelle

Posts: 7084
Registration date: Saturday April 7, 2007
Status: Moderator
Last seen: September 25, 2020

492
Oct 9, 2016 at 06:18 AM

Hello,

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

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

1 reply

Your reply

Subscribe To Our Newsletter!