Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need some help with a Google Docs spreadsheet. Let's say I've got a column and in the column I have 3 rows containing the values A, B, and C:


I need to transpose the column so that it reads horizonitally:

A     B     C

In an empty cell, I can use the function =TRANSPOSE(A1:A3) to get the rows switched into columns. My problem is that the three columns are a reference to the original column, and I can't erase the original column or it will mess up these three new columns. I also can't paste the new columns into a new spreadsheet.

How can I "unlink" the three new columns from the original column?

share|improve this question

migrated from superuser.com Aug 12 '11 at 7:59

This question came from our site for computer enthusiasts and power users.

Select the three columns, copy them and then paste them in a new row, pasting values only. Then you can erase the original column.

enter image description here

enter image description here

enter image description here

share|improve this answer

In new Google Sheets there is no need for a function. Just select B and C, Ctrl+c, select the cell immediately to the right of Aand Edit, Paste special, Paste transpose.

This creates copies of B and C but there is no linkage so those below A may be deleted without affect those to the right of A.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.