Linking Cells from Columns to Rows / Transpose Paste Special

Kevin Meek

I am trying to copy data from a source sheet to a destination sheet.  The data on my source sheet is in columns, but I want it to be shown as rows on my destination sheet.  I have tried to link several cells at a time, but it only links one cell - not the group of cells.

 

So... I tried to bring in over as column to column and I can link multiple cells just fine.  Then, I thought I could use a 'copy' and 'paste special - transpose' (like in Excel) to switch my links from columns to rows.  No such luck!

 

Anyone have any ideas on how I might be able to accomplish this?  I have large sheets with lots of data, and linking cell by cell I will be dead and buried before I finish!

 

Thanks!

J. Craig Williams

Kevin,

 

To solve this, I created an intermediary sheet that was set up linked to the input sheet vertically and the output sheet horizontally.

The intermediary sheet was set to do the internal equate from the vertical section to the horizontal one.

 

When a new project was set up, it was two simple linking actions:

1. a group of vertical cells linked to the intermediary sheet

2. a group of horizontal cells linked to the output sheet.

 

Hope that makes sense.

 

Craig