Link columns to rows

C

Charlie

There must be an easy way to do this....I just don't know
what it is. I have data in columns on one sheet that I
want to paste as a link to another sheet, but this data
has to be laid out in rows on the second sheet. I thought
selecting the entire paste area would work, but it
doesn't. I could paste the link for each cell
individually, but this would take forever.
 
F

Fable

Hi,

You want to transpose, select the column range of data copy it go t
the destination sheet and then select from the EDIT/SPECIAL PASTE
TRANSPOSE. If not try the formula =TRANSPOSE(array). Hope this helps
 
Top