Hi to all!! I need your help once again!
I would like to fill some cells with a customer id if this customer is the same as the cell bellow.
As my example below. (sorry I can upload the file through company’s policy)

CUSTOMER id CUSTOMER NAME TYPE
737346 Nikos 81
1154765 Kyriakos 81

1154780 Thanos 81

I would like to fill automatically the empty cell bellow Kyriakos the customer id 1154765 in new column.
I want in column "new" to fill with customer id and when the customer id is empty to fill the same customer id as above customer id.
like the exaple below

CUSTOMER id CUSTOMER NAME TYPE new
737346 Nikos 81 737346
1154765 Kyriakos 81 1154765
1154765
1154780 Thanos 81 1154780


thanks a lot!!!