OK, I was at work and typing fast so I don’t think I came across clear at all. I will now try to explain what I am trying to accomplish now that I am not doing more than 15 things at a time!!
I have the following worksheet Columns A thru M
A NAME
B STREET ADDRESS
C BLANK (ADDRESS2)
D CITY
E STATE
F ZIP CODE WITH 4 DIGIT EXTENTION
G A “FROM DATE” WHEN THE ADDRESS WAS REPORTED
H A “TO DATE” WHEN THE ADDRESS WAS REPORTED
I SOCIAL SECURITY NUMBER
J NAME OF EMPLOYER1
K DATE EMPLOYER 1 WAS REPORTED
L NAME OF EMPLOYER 2
M DATE EMPLOYER 2 WAS REPORTED
The problem I am having is that some people have more addresses than others. What I need to do the following. Let’s say for instance we have this….
John Smith 123 5th Street Tallahassee Fl 32301-5837 Oct-98 Nov-00 123-45-6789 Tallahassee Diner 1-Aug AJ Auto Parts Feb-00
John Smith may have 4 different listings taking up row 1-4. What I want to do is put all of John Smiths info on 1 row. (Putting the 2nd listing for John Smith and all his info starting at N1 thru Z1 and so on…. Hope this is more clear to everyone. Any help would be appreciated.
I have the following worksheet Columns A thru M
A NAME
B STREET ADDRESS
C BLANK (ADDRESS2)
D CITY
E STATE
F ZIP CODE WITH 4 DIGIT EXTENTION
G A “FROM DATE” WHEN THE ADDRESS WAS REPORTED
H A “TO DATE” WHEN THE ADDRESS WAS REPORTED
I SOCIAL SECURITY NUMBER
J NAME OF EMPLOYER1
K DATE EMPLOYER 1 WAS REPORTED
L NAME OF EMPLOYER 2
M DATE EMPLOYER 2 WAS REPORTED
The problem I am having is that some people have more addresses than others. What I need to do the following. Let’s say for instance we have this….
John Smith 123 5th Street Tallahassee Fl 32301-5837 Oct-98 Nov-00 123-45-6789 Tallahassee Diner 1-Aug AJ Auto Parts Feb-00
John Smith may have 4 different listings taking up row 1-4. What I want to do is put all of John Smiths info on 1 row. (Putting the 2nd listing for John Smith and all his info starting at N1 thru Z1 and so on…. Hope this is more clear to everyone. Any help would be appreciated.