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?