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

Kevin Meek

Hey Craig –

 

Thanks for your discussion comment, but I am still a little confused “how” you got the row to column internal equate on the intermediary sheet… would you be able to share a little more?

J. Craig Williams

Kevin,

 

I can demo it when we talk tonight.

 

Craig

Gianno_H

Hi Craig,

I'm interested to know how you do the internal equate on the intermediary sheet as well.

Would you be able to share your solution?

Thank you,

Gianno

Max_B_GDev

Hi Craig,

I am also interested in how you were able to link cells from a vertical orientation to a horizontal orientation. I am trying to create a project pipeline where I need to do exactly this.

If you could share your solution that would be great!

Thanks!

Max

 

J. Craig Williams

I wrote this today to document a way I have solved this:

http://ronin-global.com/2017/11/29/smartsheet-transposing-project-schedule/

Craig