Thanks

The query would be

select PointID, X, Y

from Points

pivot

(

max(Value)

for Axis in (X, Y)

)