7A. You can sort by the column containing the Xs to bring them together. Don't forget the cut and paste special step to remove the formulas and replace them with the data or you will have a mess.
"Dennis Marks" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > This is the way I would approach it. > 1. Insert 2 columns between email_1 and email_2. > 2. Insert 2 columns between email_2 and email_3. > 3. Copy id and name columns into the 2 sets of columns. You will now have > 3 sets of data. Each with only 1 address > 4. Move the sets so that they are in one set. Move them down and to the > left to create a single set. You can now sort the file by email. > 5. Delete the blank email records. > 6. Create a new column with a formula that displays a character if the > email address is equal to the one above it. In cell B4. =IF(B3=B2;"X";""). > Propagate down. > 7. Cut and paste special to remove the formulas. > 8. Delete the duplicates manually. > 9. Resort in id or name sequence. > > BE SURE TO CREATE A BACKUP COPY BEFORE TRYING THIS!! NO GUARANTEES! > > "Mark Phillips" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] >>I have a spreadsheet with five columns and ~1500 rows. >> >> The columns are: id, name, email_1, email_2, email_3. >> >> I want to consolidate this into three columns: id, name, email >> where I have duplicate rows if an id,name pair has different email >> addresses >> in the three email fields. >> >> Currently, there are duplicate rows in the table and lots of duplicate >> email >> addresses in the fields email_1, email_2, email_3. >> >> What would be the best way to do this? >> >> Thanks! >> >> Mark >> >> P.S. I am trying to get these name/email pairs into an email list for our >> little league so we can send out league reminders such as "don't forget >> registration is on Jan 21". >> >> -- >> Mark Phillips >> Phillips Marketing, Inc >> [EMAIL PROTECTED] >> 602 524-0376 >> 480 945-9197 fax --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
