Hi!

How big is this list?

Biff

"sharpie" wrote in
message ...

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

Currently the sheet looks something like this:

EMAIL_________ACCOUNT #
____123123
____456789
____789123
____987321



But I need it to look like this:

EMAIL_______ACCOUNT #1___ACCOUNT #2___ACCOUNT #3___ACCOUNT #4
__123123_______456789_______789123________987321



Any ideas?


--
sharpie
------------------------------------------------------------------------
sharpie's Profile:
http://www.excelforum.com/member.php...o&userid=27847
View this thread: http://www.excelforum.com/showthread...hreadid=473578