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

Kevin Meek
edited 12/09/19 in Archived 2017 Posts

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! :)




This discussion has been closed.