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