Link columns to rows

  • Thread starter Thread starter Charlie
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help!!!!!! 2
excel 2007 copy row heights 3
How to transpose data (Row to column) without losing the cell link 3
Links Causing File Size Jump 3
Copying data to the next blank row 0
Paste Values in linked Cells Only 4
how do I link to another sheet in workbook? 12
Copy Row depending on an entry 1

Back
Top