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

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

In Column 'A' there could be as little as two names the same or there could
30. Inthe 'A' column has the same name in it the information to the right
'C', 'D', 'E' ect. will be different. In other words the rest of the columns
have headers above them. When the rows are combined the data contained would
never coexist. When complete I am trying to have each name exist in only on
row with all of the other information to right of it combined as well.
--
Jake


"Rick Rothstein" wrote:

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