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