We need some more information. Will there ever be the situation where Jake
is in A4 so that one column has more than one entry? If so, how is that to
be combined? Also, where do you want the results? On the same worksheet? If
so, consecutive place by rows? Also, are all the Jake's and other names next
to each other (row by row) or can their rows be intermingled with the rows
of names?

--
Rick (MVP - Excel)


"JakeShipley2008" wrote in
message ...
I am trying to find a way to merge rows based upon a value in column A:

For example:
A1 = Jake-----B1 (Blank)-------C1 "Orange"--------D1 (Blank)
A2 = Jake-----B2 "Apple"------C2 "Blank"-----------D1 (Blank)
A3 = Jake-----B3 (Blank)-------c3 "Blank"-----------D1 "Banana"

I would like the end result to be:

A1 = Jake-----B1 "Apple"------C1 "Orange"------D1 "Banana"


On a side note Column 'A' will contain multiple names that will need to be
combined in the same way shown.

Thanks in advance,

Jake
Jake