How can I create a matrix from three columns?

Hi there,

I would like to create a matrix that looks like this:

Right now I have three columns in an excel sheet, which are Latitude (lat), Longitude (lon) and Height. Each set of lat/lon corresponds to one Height. I entered the numbers in the picture manually to give an idea of what I want, but I have thousands of lines therefore I would need a code that transpose my data accordingly.

Thanks for your help :)

Louise

[Cong Ba]

Is this an xls file or what? If yes, you can use xlsread('filename') to read it.

[Image Analyst]

Three columns????

Answer 1

[Star Strider]

See the documentation on the xlsread (link) function.