How Do You Automatically Generate New Columns in Excel

How would one, change this ...

Change this …

Email,Product
A@A.com,A
A@A.com,B
A@A.com,C
B@B.com,A
B@B.com,B

In to this …
Email,Product,Product2,Product3
A@A.com,A,B,C
B@B.com,A,B