Re: Combining information from rows
- From: vezerid <vezerid@xxxxxxx>
- Date: Wed, 2 Jul 2008 09:59:14 -0700 (PDT)
Question: are all your records like:
John Doe 1 A street
Jane Doe 3 B str
John Doe 212-555-5555
Mike Doe 7 C str
John Doe affil1
Jane Doe 313-444-4444
Mike Doe 414-666-6666
Jane Doe affil2
Mike Doe affil3
In other words, (1) do you always have the key in first column? (2) is
phone always in a later row than address and affiliation in a later
row than phone?
On Jul 2, 7:43 pm, Danielle <Danie...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
I have an excel spreadsheet with lots of duplicate contacts, but their
information is spread throughout the different rows. For example, I have 3
rows for John Doe, but his address is in the first row, his phone number is
in the second row, and his affiliation is in the third row.
Is there a way to merge the information from all three rows into one? I have
a few thousand records like this.
Thanks!
.
- Prev by Date: Re: OLD PROBLEM without SOLUTION
- Next by Date: Re: Calculating of time
- Previous by thread: Re: check certain cells for data before saving file
- Next by thread: Re: Combining information from rows
- Index(es):
Relevant Pages
|
