| T O P I C R E V I E W |
| nina_hs |
Posted - 02/15/2017 : 07:03:16 AM
Hello,
I am having trouble getting my data into the correct shape for a matrix.
The data I want to show has been recorded over a flat surface like this:
x1..x2..x3..x4
x5..x6..x7..x8
x9...
But I receive a column with the values looking like this from the measurement program:
x1
x2
x3
x4
x5
...
Is there a possibility to change the format and insert the data into a matrix for 3D-representation?
Best regards
Nina
Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 2016 (64 bit)
Operating System: Windows 7 |
| 2 L A T E S T R E P L I E S (Newest First) |
| nina_hs |
Posted - 02/15/2017 : 09:59:39 AM
Hi Hideo,
this is exactly what I was hoping for, thanks a lot!!
For a 4*4 matrix it would have been possible to convert the columns manually, but my sets are a bit bigger, so this automated conversion works great!
Thanks again and kind regards
Nina |
| Hideo Fujii |
Posted - 02/15/2017 : 09:35:03 AM
Hi Nina,
Please try the following: (Suppose your data are originally stored in a worksheet column.)
1) Highlight the data column, and choose "Worksheet: Split Columns" menu.
2) In the tool, set the Subgroup Method to "By Every Nth Row", and enter 4 to N field. Click OK.
This produces a worksheet with 4 columns as arranged like:
x1 x2 x3 x4
x5 x6 x7 x8
x9...
3) Choose "Worksheet: Convert to Matrix: Direct" menu, and click OK.
This creates a matrix sheet with the above data.
This works as you wanted?
--Hideo Fujii
OriginLab |
|
|
