I'm trying to do a mailmerge from Excel.  Below is a hypothetical spreadhseet
sample:

Bob --- 123 Any St. --- red car
Bob --- 123 Any St. --- blue car
Bob --- 123 Any St. --- yellow car
Jane --- 321 Any St. --- red car
Jane --- 321 Any St. --- green car
Sue --- 555 Any St. --- red car

The merged letters would appear as follows:

(letter 1)
Bob, of 123 Any St., has a red car, blue car, yellow car.
(letter 2)
Jane, of 321 Ant St., has a red car, green car.
(letter 3)
Sue, of 555 Any St., has a red car.

Rearranging the data is not feasible (over 1200 lines).  Any suggestions on
how to do this?