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