Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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:

Column:
A
B
C

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

Columns:
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
add comment

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

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

1 Answer

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
add comment

Your Answer

 
discard

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