MATLAB: How to transform a XYZ-Array into a XxY-Matrix with Z as values of each Mxy-Component and vice versa

arrayMATLABmatrix manipulationmeshsurf

Hi, I have a table XYZ with three columns (xyz) as below:
1  1  1
1  2  2
1  3  3
2  1  4
2  2  5
2  3  6
3  1  7
3  2  8
3  3  9
and I want to transform it into a Mxy-Matrix with Z as value for each Mxy pair as follows:
1  4  7
2  5  8
3  6  9
On the other hand I may have directly the Matrix Mxy and would like to obtain the XYZ-table.
I already tried mesh, meshgrid, ndgrid, surf and etc… as documented, but nothing worked as I wished. It is possible that I did not understand yet how to use this commands.
I wonder if someone could tell me how to write the command to convert:
1) Table XYZ to Matrix Mxy with Z as values of each Mxy-pair 2) Matrix Mxy to Table XYZ
I thank you in advance for your help
Emerson

Best Answer

accumarray(XYZ(:,[2 1]), XYZ(:,3)]
Related Question