Transpose Duplicate Rows to Separate Columns

I need the rows that have duplicate email entries to be converted to columns. See attached..

112233 | Mr John Smith
112233 | Mr Steve Tyler
112233 | Mr Mike Brown
584737 | Julie Green
205382 | Fred Flint
205382 | Peter Robinson

Would become:

112233 | Mr John Smith | Mr Steve Tyler | Mr Mike Brown
584737 | Julie Green
205382 | Fred Flint | Peter Robinson

Your attached file is somewhat larger than the simple example you quoted in your post. What do you want to happen to the other fields of data for the duplicate records?

Pete

Hi Pete,
Thanks for responding. It would be nice if the other data can be copied but the most important part is the account numbers are vertical and email address are horizontal.