MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Transposing Links


Posted by David Campbell on August 02, 2001 8:11 AM

I have a spreadsheet that has data arranged with columns and rows one way to make the entry and editing of information easier, and am trying to make a linked sheet with that information transposed to make it easier to gleen usful information. I have tried copy and pasting special links into a second sheet then copying and pasting special formulas transpose into a third, but in the third the links are not transposed, they are just like the first sheet. What am I doing wrong? I have no use for the second sheet except as an intermedeary step to produce the third since Excel dosn't seem to want to let me copy, paste special, transpose and paste link at the same time. I am using Excel 97.


Posted by Barrie Davidson on August 02, 2001 9:09 AM

David, you can transpose your numbers via a formula. Here's how:

Let's assume you have data in 20 columns in A1:T1 that you want to transpose to 20 rows starting at A4. Highlight the cells from A4 to A23 (20 data points) and input the following formula without hitting the enter key:
=TRANSPOSE(A1:T1)
After you have input the formula, press CTRL+SHIFT+ENTER to enter it as array formula.

Hope this helps you out,
Barrie