Merge all cells before an empty cell in a column

[sabrez]

Hi

I have the below table:

OrderID	Price
1	$18
1	$18
1	$18
2	$16
3	$20
4	$12
4	$12
4	$12

<tbody>
</tbody>

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

OrderID	Price
1	$18
1
1
2	$16
3	$20
4	$12
4
4

<tbody>
</tbody>

Please suggest how.


Regards
Sabrez

 

[Kaper]

Is :

OrderID	Price
1	$18
1
1
2	$16
3	$20
4	$12
4
4

<tbody>
</tbody>

Realy needed?
Wouldn't:

OrderID	Price
1	$18
2	$16
3	$20
4	$12

<tbody>
</tbody>

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

<tbody>
</tbody>