Merge Data from rows

[bigdaddy123]

I have a table that has data split between rows. I need to merge the data, if possible. Please see example.

If "Name" is the same, insert content from cell "B2" into "D2" and place content from "C5" into "E2". I think I could build the formula if the number of identical "Name" rows were always the same, but they vary. Some "Name's" have 4, some 10, some 20 rows. The number of rows is always an even number.


[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]Name[/TD]
[TD]INFO1[/TD]
[TD]INFO2[/TD]
[TD]Result1[/TD]
[TD]Result2[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]Name1[/TD]
[TD]Need1[/TD]
[TD]DoNotNeed4[/TD]
[TD]Need1[/TD]
[TD]Need4[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]Name1[/TD]
[TD]Need2[/TD]
[TD]DoNotNeed5[/TD]
[TD]Need2[/TD]
[TD]Need5[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD]Name1[/TD]
[TD]Need3[/TD]
[TD]DoNotNeed6[/TD]
[TD]Need3[/TD]
[TD]Need6[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD]Name1[/TD]
[TD]DoNotNeed1[/TD]
[TD]Need4[/TD]
[TD]<blank></blank>[/TD]
[TD]<blank></blank>[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD]Name1[/TD]
[TD]DoNotNeed2[/TD]
[TD]Need5[/TD]
[TD]<blank></blank>[/TD]
[TD]<blank></blank>[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD]Name1[/TD]
[TD]DoNotNeed3[/TD]
[TD]Need6[/TD]
[TD]<blank></blank>[/TD]
[TD]<blank></blank>[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD]Name2[/TD]
[TD]Need7[/TD]
[TD]DoNotNeed9[/TD]
[TD]Need7[/TD]
[TD]Need9[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD]Name2[/TD]
[TD]Need8[/TD]
[TD]DoNotNeed10[/TD]
[TD]Need8[/TD]
[TD]Need10[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD]Name2[/TD]
[TD]DoNotNeed7[/TD]
[TD]Need9[/TD]
[TD]<blank></blank>[/TD]
[TD]<blank></blank>[/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD]Name2[/TD]
[TD]DoNotNeed8[/TD]
[TD]Need10[/TD]
[TD]<blank></blank>[/TD]
[TD]<blank></blank>[/TD]
[/TR]
</tbody>[/TABLE]

 

[oldbrewer]

why C5 is it the last but one row with same name - please define your rule more explicitly

 

[bigdaddy123]

In this scenario, there are 6 rows with the same "Name". The first half of the rows (2-4) have the data in column "B" that I need. The second half of the rows (5-7) have data in column "C" that I need.

If there where 10 rows with the same "Name", it would be rows 2-6 with needed data in column "B" and rows 7-11 with data in column "C".

These are vendors (Name), there is always an even number of rows for each vendor. The first half of the rows contains a plain text product name in column "B" and the same text wrapped in HTML tags in column "C". The second half of the rows has product info in plain text in column "B" and the same info wrapped in HTML tags in column "C". The first row of the first half of rows always relates to the first row of the last half of rows, the second with the second, etc.

I need to get the plain text product name (column "B" first half of rows) and the HTML info (column "C" last half of rows) onto the same row.