Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Linking Cells from Columns to Rows / Transpose Paste Special
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!
Comments
-
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
-
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?
-
Kevin,
I can demo it when we talk tonight.
Craig
-
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
-
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
-
I wrote this today to document a way I have solved this:
http://ronin-global.com/2017/11/29/smartsheet-transposing-project-schedule/
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives