X-Y coordinates retrieval

%3CLINGO-SUB%20id%3D%22lingo-sub-2405762%22%20slang%3D%22en-US%22%3EX-Y%20coordinates%20retrieval%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2405762%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20I%20have%20about%206500%20entries%20of%20geometry%20points%20which%20has%20columns%20for%20x%2Cy%20coordinates%20and%20origin%20and%26nbsp%3B%20destination%20names.%20Now%20I%20need%20to%20create%20four%20columns%20and%20retrieve%20destination-X%20values%20and%20destination-Y%20values%20then%20another%20two%20columns%20for%20Origin-X%20values%20and%20Origin-Y%20values.%20How%20do%20I%20go%20about%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2405762%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2405804%22%20slang%3D%22en-US%22%3ERe%3A%20X-Y%20coordinates%20retrieval%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2405804%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1068688%22%20target%3D%22_blank%22%3E%40williamgyamfik%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20you%20are%20going%20to%20need%20to%20describe%20the%20problem%20in%20greater%20detail%20and%20to%20mock%20up%20some%20data%20to%20demonstrate%20the%20idea.%26nbsp%3B%20At%20first%20sight%2C%20I%20would%20say%20that%20a%20point%20may%20have%20a%20name%3B%20if%20it%20lies%20on%20a%20surface%2C%20its%20position%20may%20be%20represented%20by%20a%20coordinate%20pair%3B%20but%20a%20point%20does%20not%20have%20an%20origin%20nor%20a%20destination.%26nbsp%3B%20Only%20a%20directed%20edge%20will%20have%20such%20properties.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

So I have about 6500 entries of geometry points which has columns for x,y coordinates and origin and  destination names. Now I need to create four columns and retrieve destination-X values and destination-Y values then another two columns for Origin-X values and Origin-Y values. How do I go about this.

2 Replies

@williamgyamfik 

I think you are going to need to describe the problem in greater detail and to mock up some data to demonstrate the idea.  At first sight, I would say that a point may have a name; if it lies on a surface, its position may be represented by a coordinate pair; but a point does not have an origin nor a destination.  Only a directed edge will have such properties.

@Peter Bartholomew Hello Peter you're right. I think I didn't explain the situation well on here but attached is a screenshot of the data in Excel. I would be happy if you could provide sequential steps to achieve the destination and origin coordinates.