transposing problem, may need some kind of function

  • Thread starter Thread starter scudooder
  • Start date Start date
S

scudooder

Hello all,

I have this problem where I have a list of people's information a
follows:

Name
Email
address
city
state
zip
phone


I wanted the information in rows instead of columns so I used th
transpose option. The problem I am having is that I do not hav
everyone's email address or phone, or city, etc.. So when I use th
transpose option, it pastes the information under the wrong colum
headings. Is there a way to add a blank or NULL to the row where I d
not have the person's information so that all other data is kept i
sync with the column headings? I would do this manually, but I have
ton of people and want to avoid human error by not doing it manually.


thank
 
So you are saying the number of rows for an individual could vary (presumably)
from 1 to 7. I think you would need do do this with VBA, but for that to work,
you also need *unequivocal* criteria to determine (a) where one record ends
and the next begins -- i.e. how many lines are there for this person, and(b)
if it's not 7 lines, which lines are missing (i.e. is it the address or the
email?). This is next to impossible, so the solution is, as you propose, to
add blank lines for the missing info, so there are 7 lines for each person.
Problem is, you have to answer the same questions -- (a) and (b) above -- to
be able to do that with code. IMO, this is, unfortunately, a manual operation.

Is this data imported from some other program? Is so, re-export, so the blanks
are included for missing information?
 
Back
Top