I am still looking for a solution to this issue?

I have an excel file that has several people listed several times in
different rows. The only common information that shows these individuals as
the same person is their SSN. The same individual is listed several times in
different rows due to each row showing the same individual with different
products that they have purchased. Is their a macro that will read the SSN
column - looking for the same SSN, and if the same SSN exists, combine the
information into one row?


The data looks like:

Amy burden 111-11-1111 LTD
John Burden 111-11-1111 STD
sam burden 111-11-1111 CHILD
kim swafford 111-11-1112 PS 1000
ale swafford 111-11-1112 PS PLUS

The reason their are repetive SSNs, but different names are due to family
members will sign up for different products but they will be listed under
owners SSN, that is at the beginning of each repetitive SSN. I would like the
data to look like:

Amy burden 111-11-1111 LTD STD CHILD
kim swafford 111-11-1112 PS
1000 PS PLUS

Hello,

Have a look at the VBA forum
http://forums.microsoft.com/MSDN/Sho...ID=74&SiteID=1

I did something similar for someone on there.
Thread name is "Moving Data"

ChasAA

"Help?" wrote:

I am still looking for a solution to this issue?

I have an excel file that has several people listed several times in
different rows. The only common information that shows these individuals as
the same person is their SSN. The same individual is listed several times in
different rows due to each row showing the same individual with different
products that they have purchased. Is their a macro that will read the SSN
column - looking for the same SSN, and if the same SSN exists, combine the
information into one row?


The data looks like:

Amy burden 111-11-1111 LTD
John Burden 111-11-1111 STD
sam burden 111-11-1111 CHILD
kim swafford 111-11-1112 PS 1000
ale swafford 111-11-1112 PS PLUS

The reason their are repetive SSNs, but different names are due to family
members will sign up for different products but they will be listed under
owners SSN, that is at the beginning of each repetitive SSN. I would like the
data to look like:

Amy burden 111-11-1111 LTD STD CHILD
kim swafford 111-11-1112 PS
1000 PS PLUS

ChasAA,
I tried looking for the thread you have given me, but no success. Are there
anymore suggestions

"ChasAA" wrote:

Hello,

Have a look at the VBA forum
http://forums.microsoft.com/MSDN/Sho...ID=74&SiteID=1

I did something similar for someone on there.
Thread name is "Moving Data"

ChasAA

"Help?" wrote:

I am still looking for a solution to this issue?

I have an excel file that has several people listed several times in
different rows. The only common information that shows these individuals as
the same person is their SSN. The same individual is listed several times in
different rows due to each row showing the same individual with different
products that they have purchased. Is their a macro that will read the SSN
column - looking for the same SSN, and if the same SSN exists, combine the
information into one row?


The data looks like:

Amy burden 111-11-1111 LTD
John Burden 111-11-1111 STD
sam burden 111-11-1111 CHILD
kim swafford 111-11-1112 PS 1000
ale swafford 111-11-1112 PS PLUS

The reason their are repetive SSNs, but different names are due to family
members will sign up for different products but they will be listed under
owners SSN, that is at the beginning of each repetitive SSN. I would like the
data to look like:

Amy burden 111-11-1111 LTD STD CHILD
kim swafford 111-11-1112 PS
1000 PS PLUS

Okay, I'll have a look at this tomorrow.
Is the initial data in three columns?
Is there only one product per row?
Where do you want the new data placed?

After the data is manipulated, do you want only one name per row?
How is the "owner" of the SSN identified , or is it always the first name in
the column.

Will SSN 111-11-1111 ever appear again after 111-11-112 for example?

Leave me this info and I'll have a look tommorow

Chas

"ChasAA" wrote:

Hello,

Have a look at the VBA forum
http://forums.microsoft.com/MSDN/Sho...ID=74&SiteID=1

I did something similar for someone on there.
Thread name is "Moving Data"

ChasAA

"Help?" wrote:

I am still looking for a solution to this issue?

I have an excel file that has several people listed several times in
different rows. The only common information that shows these individuals as
the same person is their SSN. The same individual is listed several times in
different rows due to each row showing the same individual with different
products that they have purchased. Is their a macro that will read the SSN
column - looking for the same SSN, and if the same SSN exists, combine the
information into one row?


The data looks like:

Amy burden 111-11-1111 LTD
John Burden 111-11-1111 STD
sam burden 111-11-1111 CHILD
kim swafford 111-11-1112 PS 1000
ale swafford 111-11-1112 PS PLUS

The reason their are repetive SSNs, but different names are due to family
members will sign up for different products but they will be listed under
owners SSN, that is at the beginning of each repetitive SSN. I would like the
data to look like:

Amy burden 111-11-1111 LTD STD CHILD
kim swafford 111-11-1112 PS
1000 PS PLUS