G
Guest
Hi -
In my data, there are 5 columns, CAR, TRUCK, NAME, CITY, STATE. The first
two columns will have a X in it if the person has a CAR or TRUCK. With the
data I am pulling from, if the same person has both a Car and Truck, they
will show up twice in seperate rows. I would like to find when a person has
both and combine it to one row (with a X in each CAR and TRUCK). So from:
CAR TRUCK NAME CITY STATE
X Mike Orlando FL
X Mike Orlando FL
To:
CAR TRUCK NAME CITY STATE
X X Mike Orlando FL
Help please...I am stuck.
Thanks,
Mike
In my data, there are 5 columns, CAR, TRUCK, NAME, CITY, STATE. The first
two columns will have a X in it if the person has a CAR or TRUCK. With the
data I am pulling from, if the same person has both a Car and Truck, they
will show up twice in seperate rows. I would like to find when a person has
both and combine it to one row (with a X in each CAR and TRUCK). So from:
CAR TRUCK NAME CITY STATE
X Mike Orlando FL
X Mike Orlando FL
To:
CAR TRUCK NAME CITY STATE
X X Mike Orlando FL
Help please...I am stuck.
Thanks,
Mike