I have three points from two layers ( Point 2539 and 2538 from one layer lets say X and point AL101974 from layer Y ) ( Refer figure-1 below).
Point 2539 and 2538 has multiple attribute information ( figure-2) i wanted to add those information into point AL10974 along with distance of each point from AL10974 ( this distance we need to create not already in attribute)
I have used the Distance to nearest hub (Points) tool to get distance and other information but this will populate two columns ( when i am putting source layer as as layer X ) - fig 3 for reference.
I wanted to all these in one row so i will calculate further statistical analysis on it.