Adding the Purchase Order number for the sub item|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Dear Sunny,

I have a series PO data with sub item in the list. Example PO A with sub item 1,2,3. In the line sub item #2 and #3, it has no PO number PO A. I would like to adding the PO number PO A at the sub item #2 and #3.

So in the end the list would be, PO A with sub item 1,

                                             PO A with sub item 2,

                                             PO A with sub item 3.

Please see PO number 004/1/2018/MKM-PO in the attachment, in the sheet "Pembelian 2018 BEFORE" and in the sheet "Pembelian 2018 AFTER"

Thank you and regards,

Chandra