Hello. I am trying to edit the table data. Think that we have the z values according to each x and y values. Iwould like get the x values according to each y and z values.
As an example;
X=[1 2 3 4 5];Y=[30;40;50;60];Z=[1 2 3 4 5; 3 4 5 6 7; 5 6 7 8 10; 7 8 10 11 13];
So the table is;
Y ^ 1 2 3 4 5 -> X | --------------- 30 ! 1 2 3 4 5 40 ! 3 4 5 6 7 50 ! 5 6 7 8 10 60 ! 7 8 10 11 13
I would like rearrange the table which looks like this:
Y ^ 1 4 7 10 13 -> Z | --------------- 30 ! 1 4 40 ! 2 5 50 ! 3 5 60 ! 1 5
To be able to make an accurate interpolation (and no need to extrapolation); the given data table is extendable. I men it could be provided some more extra values. So the given data table could be like this :
Y ^ 1 2 3 4 5 6 7 ...-> X | -------------------- 30 ! 1 2 3 4 5 6 7 40 ! 3 4 5 6 7 8 9 50 ! 5 6 7 8 10 11 12 60 ! 7 8 10 11 13 15 16 70 ! 9 10 12 13 15 17 18 80 !10 11 13 14 16 18 20 ...
And I need the z data table 1-13 only.
Best Answer