| T O P I C R E V I E W |
| blues3333 |
Posted - 01/15/2021 : 07:34:11 AM
Hi. I am working with a single column of let's say 100 rows of numeric data which I need to convert into a 10x10 matrix, in the following way:
row 1 to 10 to the first matrix column
row 11 to 20 to the second matrix column
row 21 to 30 to the third matrix column
and so on.
Any help will be welcome!
(The true column data is very long 1 x 10^7 rows, and the real matrix will be 20000 x 500, so I need some automatic option.)
Regards! |
| 3 L A T E S T R E P L I E S (Newest First) |
| YimingChen |
Posted - 01/15/2021 : 4:09:37 PM
Then you will have to upgrade Origin.
James |
| blues3333 |
Posted - 01/15/2021 : 1:02:12 PM
quote:
Originally posted by YimingChen
Hi,
You can use menu Worksheet->Split Columns... to unstack the single column to a matrix.
James
Thanks, James, but I can't find this function in my version of origin (originpro 8). The only split function is worksheet -> split workbooks |
| YimingChen |
Posted - 01/15/2021 : 08:58:01 AM
Hi,
You can use menu Worksheet->Split Columns... to unstack the single column to a matrix.
James |
