Final table table resident help

[coolguy123]

hi

i want one final table from this 

load 

order_id

concat(serial, ‘,’) as finalserial

from abc

group by order_id

load

Order_no & order-month

concat(serial, ‘,’) as finalserial

from abc

group by Order_no & order-month

but I need final table with only order_id but both finalserial and no null fields  

load 

order_id

finalserial 

from abc