How do I create a single point from a csv file that has multiple records for the same point?

196
0
09-13-2019 11:09 AM
JeffJensen3
New Contributor II

Software ArcGIS Pro 2.4

I have a csv file that has multiple records (2 to 6 lines) for a single point.  How can I combine all of them to a single point and maintain all of the record information?

Existing Table

Address_IDProductAttribute
1001Phonea
1001Internetb
1001Cable TVc
1001

Desired outcome

Address_IDProduct_1Product_2Product_3Attribute_1Attribute_2Attribute_3
1001PhoneInternetCable TVabc


The csv file does have the latitude and longitude so Display XY Data can be used.
I have included a demo csv file.






0 Kudos
0 Replies