Merge all cells before an empty cell in a column

[sabrez]

Hi

I have the below table:

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]OrderID[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]$18[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]$18[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]$18[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]$16[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]$20[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]$12[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]$12[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]$12[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Now, I want to merge values in the column Price for duplicate values in Order ID, like below:

[TABLE="class: grid, width: 107"]
<tbody>[TR]
[TD="align: center"]OrderID[/TD]
[TD="align: center"]Price[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]$18[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]$16[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]$20[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]$12[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[/TR]
</tbody>[/TABLE]

Please suggest how.


Regards
Sabrez

 

[Kaper]

Is :
[TABLE="class: grid, width: 107"]
<tbody>[TR]
[TD="align: center"]OrderID[/TD]
[TD="align: center"]Price[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]$18[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]$16[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]$20[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]$12[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[/TR]
</tbody>[/TABLE]

Realy needed?
Wouldn't:
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]OrderID[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]$18[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]$16[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]$20[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]$12[/TD]
[/TR]
</tbody>[/TABLE]

be enough?

If so, use remove duplicates from data ribbon.


First effect could be obtained with helper column with formula (in C2):

=if(A2=A1,"",B2)

Copy this formula down,
copy column C
and paste special as values to column B
[TABLE="class: grid, width: 107"]
<tbody>[TR]
[/TR]
</tbody>[/TABLE]