transpose on bigger datasets?

Dear all,


I work with (relatively) large data tables and appreciate gnumeric for its stability and speed. I need some advice concerning the use of gnumeric and the function “transpose”.  I have used “transpose” successfully on small datasets.


Problem :


I have a matrix size ca 12345678x9 (ca 10^8 elements, numeric and text fields), in a gnumeric spreadsheet.

I want the transposed matrix 9x12345678.


How is this best done?


What dosnt work :


·         Copy paste special - transpose (bug?)

·         Marking the entire spreadsheet (bug?), when using transpose.

·         The first step when using “transpose” should be to mark a region of size 9x12345678. This is difficult to do “manually”. Can this be done in another way?



I have a 64_x86 linuxmint machine with lots of memory.








[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]