I'm going to give you a method that assumes that there are a maximum of 2
email addresses per company. You can modify this procedure for whatever the
maximum email count is - you just have to use more columns.

Step 1:

Assume you have data starting in Row5

In Cell C5 enter the following formula: =B6

In Cell D5 enter the following formula: =IF(A5=A6,1,0)

Step 2:

Copy these formulas all the way down. You will now have rows that
contain either a 1 or a 0 in column D. The rows that have a 1 should be what
you want.
Copy and paste special values for columns C and D. Then sort on column D to
get just the data you want.



"cyb3rwolf" wrote:

forgive me, not that experienced with exel. I am using exel 2007. I have a
spread sheet that lists off names of companies and lists e-mail contacts for
that company. Column A lists the different companies, and column B lists the
e-mail addresses. All companies have at least 2 e-mail contacts, so columna
will have the same company name repeated for howmany e-mail contacts there
are for that company in column b. What i need to do is only have one line
for each company, with each of the columns after that having the different
e-mail addresses. (Column A would be the company, column b would be the first
e-mail contact, column c would be the second e-mail contact, etc.). Anybody
help me out in an easy way to accomplish this? It is a very large spread
sheet.