Is there a way to parse/delete this data?

[Jon_HUNT]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I am working with two columns of data, i.e.
Column A Column B
BBA Phone number
Name Phone number
Title Phone number
address blank
city email address

I want to delete all the data except the name and email address. I'm doing this manually, but it is a laborious process. Is there any way to break this out into 10 columns and then delete columns? Or is there another way to accomplish this.
Thanks.

 

[Carl Witthoft]

Sort the entire database by column A. Then all the "Name' rows will be
together and all the "city" rows will be together. Select the blocks of
rows you don't want and delete them.

But I would recommend instead reading a little about Advanced FIltering,
and then create the sub-database you want without losing all that info.
Invariably you'll find two weeks later that you need all the stuff that
was deleted

 

[Jon_HUNT]

Apparently I didn't explain the problem, because the solution will not work. If you look at my example I should have included row numbers. For instance A1 contains BBA while B1 contains a phone number. A2 contains the name, which I want. B5 contains the email which I want.

 

[Bob Greenblatt]

Apparently I didn't explain the problem, because the solution will not work.
If you look at my example I should have included row numbers. For instance A1
contains BBA while B1 contains a phone number. A2 contains the name, which I
want. B5 contains the email which I want.

AS Carl suggested, Advanced filtering is the way to go here. Create a
filtered list of the unique names. Then use a combination of the match and
offset functions to get the email address. Then you can paste the values to
another part of the sheet or to another sheet.

 

[Jon_HUNT]

Again...I have failed to communicate, but I think I know enough to know it can't be done. I have two columns of data. Somewhere in column A there are 269 names and somewhere in column B there are 269 email addresses. The name and email address are not on the same row. I can't find decent information on advanced filtering, but it seems illogical that there would be a way to identify/sort to find names...email addresses maybe because of the unique character.

 

[Bob Greenblatt]

Again...I have failed to communicate, but I think I know enough to know it
can't be done. I have two columns of data. Somewhere in column A there are 269
names and somewhere in column B there are 269 email addresses. The name and
email address are not on the same row. I can't find decent information on
advanced filtering, but it seems illogical that there would be a way to
identify/sort to find names...email addresses maybe because of the unique
character.

I think you are communicating fine. You just do not understand the
techniques. Sort or extract the unique names in the first column to get a
list of the 269 names. Then use a match and offset formula to grab the email
address for the name. The match will return the row containing the name, and
the offset function will get you to the next column and three rows down to
grab the email.

 

[Jon_HUNT]

Can you point me to a site that explains how to sort or extract the unique names and to use a match and offset formula?

Thanks.

 

[Bob Greenblatt]

Can you point me to a site that explains how to sort or extract the unique
names and to use a match and offset formula?

Thanks.

There is no site that will do this. Look in Excel Help. Search for
³Unique². Similarly look in help for the match and offset functions. If you
reply again with your data layouts and columns we can help with the
formulas, but you¹ll have to do some research and get started your self.