Possibly Simple - Pivoting Vertical to Horizontal

[AnetShe]

I'm stuck on what I think is a simple issue and can’t seem to figure out what is needed – any help is appreciated!
I am looking to take a vertical list of data and pivot only two columns into stretching across the row, while keeping only one line for each unique Customer ID. My list has about 2000 rows of data with about 1000 unique IDs.

The original data looks like:

Customer ID | Company Name | Name | Email
PUS0000001 | Yoga Town | Kim Jones | sara@gmail.com
PUS0000001 | Yoga Town | Dan Porter| dan@gmail.com

I am looking to switch the format to:

Customer ID | Company Name | Name | Email | Name | EmailPUS0000001 | Yoga Town | Kim Jones | sara@gmail.com | Kim Jones | sara@gmail.com


Let me know if you have questions and THANK YOU!!

 

[AnetShe]

Thank you for this! It works with one slight issue - the name & email columns are out of order, it starts with Name 100, then 101 then 10 to 19, then 1, then starts with 20 to 29.
I think it is putting them in numerical order by digit but not true numerical order (1-101), is it possible to fix the order?

 

[sandy666]

post representative example with 100 or more generic names and emails