Take the 2-minute tour ×


alt text


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



share|improve this question
add comment

1 Answer

up vote 13 down vote accepted




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


