| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combine like rows
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine rows and Qty | Excel Discussion (Misc queries) | |||
| How to combine rows? | Excel Discussion (Misc queries) | |||
| How do I combine worksheets w/o enough rows to combine? | Excel Worksheet Functions | |||
| Combine rows | Excel Discussion (Misc queries) | |||
| how to combine the multiple rows into one rows? | Excel Worksheet Functions | |||
Threaded Mode
