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 #
(e-mail address removed)____123123
(e-mail address removed)____456789
(e-mail address removed)____789123
(e-mail address removed)____987321



But I need it to look like this:

EMAIL_______ACCOUNT #1___ACCOUNT #2___ACCOUNT #3___ACCOUNT #4
(e-mail address removed)__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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function in Excel to count and list number of entries of text valuesin a row. 2
Formula to count the number of unique dates 7
Custom Reporting Across Sheets 1
Synchronization problems while moving folders to new email 1
Merging duplicate entries in Excel or deleting the duplicates (Exc 1
Uniquely number a set of names 3
formula assistance needed 5
Need Help w/ formulas for multiple criteria 4

Top