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

JeffJensen3 — Fri, 13 Sep 2019 18:09:23 GMT

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.

topic How do I create a single point from a csv file that has multiple records for the same point? in Data Management Questions

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