Filtering a list with duplicates

[sharpie]

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 #
[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________987321



Any ideas?

[Biff]

Hi!

How big is this list?

Biff

"sharpie" <[email protected]> wrote in
message news:[email protected]...
>
> 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 #
> [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________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
>

[sharpie]

about 45,000 including the duplicates

[Biff]

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

Biff

"sharpie" <[email protected]> wrote in
message news:[email protected]...
>
> about 45,000 including the duplicates
>
>
> --
> sharpie
> ------------------------------------------------------------------------
> sharpie's Profile:
> http://www.excelforum.com/member.php...o&userid=27847
> View this thread: http://www.excelforum.com/showthread...hreadid=473578
>