Filtering a list with duplicates

S

sharpie

I need help. Is there aynone out there who can do some data tricks fo
me in Excel. I have a list of emails and associated account numbers
The problem is that one email may have 20+ account numbers associate
with it, so I need to filter the spreadsheet to de-dupe the emails bu
keep all associated account numbers.

Currently the sheet looks something like this:

EMAIL_________ACCOUNT #
[email protected]____123123
[email protected]____456789
[email protected]____789123
[email protected]____987321



But I need it to look like this:

EMAIL_______ACCOUNT #1___ACCOUNT #2___ACCOUNT #3___ACCOUNT #4
[email protected]__123123_______456789_______789123________98732



Any ideas
 
B

Biff

That's too big to do what I was thinking. It would take forever to
calculate.

Biff
 
Top