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 have a spreadsheet in Google Docs with two data rows and lots of columns like so:

alt text

Is it possible to easily convert these rows into two columns and lots of rows (obviously retaining all information and formulas)? In other words, to something like this:

 19.9.2009   967,15 €
 28.9.2009   950,78 €
12.11.2009   942,03 €
..           ..

There's probably a neat mathematical term for such a conversion, but I don't remember which (matrix something?). Feel free to suggest a better name for the question.

Edit: To clarify, ultimately I want to get rid of the original (two row) version and continue working on the converted one. TRANSPOSE(), mentioned by Al Everett, got me very close but not quite there. I want the raw data in the transposed version, not cells that mirror the original ones.

share|improve this question
add comment

1 Answer

up vote 14 down vote accepted

You want to use the TRANSPOSE() function. (Google help: Array functions)

In the upper left cell where you want this to appear, enter =TRANSPOSE(A5:Z6) (or whatever your data range happens to be).

If you want the raw data back, you can copy and paste the values into a fresh set of cells.

share|improve this answer
Thanks! TRANSPOSE() does it. However, I want to throw away the original rows and continue working on only the transposed version. So yes, I'd like the raw data, not cells that "mirror" the original cells. I tried copy-pasting, but just got empty cells as result (even when copy-pasting to a whole new spreadsheet). Could you elaborate on how to get the raw data back? –  Jonik Sep 22 '10 at 10:56
Highlight the cells you want to copy. Choose "Edit | Copy". Put your cursor on a new, empty cell. Choose "Edit | Paste values only". –  Al E. Sep 22 '10 at 12:13
Ah, I totally missed the "Paste values only" option. Excellent, thanks! –  Jonik Sep 22 '10 at 12:53
I'm happy to help. –  Al E. Sep 22 '10 at 12:56
add comment

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.