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

JeffJensen3

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.

Demo.csv.zip

Untitled.jpg

Laura_B_0-1639419572728.png