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]
