Finding Distance Between Each Point (not the diagonal distance)

Hi all, I am trying to calculate distance between 50 points. The coordinates of the points are given in the coordinates.xlsx excel file. 1st column is the X coordinate and the 2nd column is Y coordinate. I want to create a 50x50 matrix which shows distances between those points, but I cannot move diagonally. I can only move in X and Y coordinates to calculate distance.

Answer 1

[Matt J]

x=XY(:,1); y=XY(:,2);

result=abs(x-x.')+abs(y-y.');

Answer 2

[Matt J]

result=pdist2(XY,XY,'cityblock')