Transposing Links

N

Nathan

I'm trying to link one file to another and copy the information. One file lists the info in a column, the other in a row, and I want to be able to drag (copy and paste) the linked info across the row (from the column) in my new file. Is this possible

Thanks for your help.
 
D

Drabbacs

I don't think you can do a drag. What you can do is copy
the column and do a paste special->transpose.

-----Original Message-----
I'm trying to link one file to another and copy the
Click to expand...
information. One file lists the info in a column, the
other in a row, and I want to be able to drag (copy and
paste) the linked info across the row (from the column) in
my new file. Is this possible?
 
N

Nathan

The idea is for the sheets to update automatically without manually copying and pasting. Is this possible? Thanks
 
D

Dave Peterson

Say your first range is 12 rows by 1 column (say A1:A12 on sheet1)

On the second sheet, select a range 12 columns by 1 row (say a1:L1 on sheet2)

type this formula:
=transpose(sheet1!a1:a12)

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)
 
Top