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_ID | Product | Attribute |
---|
1001 | Phone | a |
1001 | Internet | b |
1001 | Cable TV | c |
1001 | | |
Desired outcome
Address_ID | Product_1 | Product_2 | Product_3 | Attribute_1 | Attribute_2 | Attribute_3 |
---|
1001 | Phone | Internet | Cable TV | a | b | c |
The csv file does have the latitude and longitude so Display XY Data can be used.
I have included a demo csv file.