MS query to obtain a single row of data with multile rows

Dear experts,

I would like to find out how can I modify my query to change the way my query result displays.

Here is my query:

SELECT product_id, warehouse_loc
FROM inventory
ORDER BY product_id

My display result will look like this:

product_id              warehouse_loc
NX-1233-01             B1-2
NX-1223-01             B2-2
Nx_1223-01             B3-1

Is there a way that I can modify my result to look like this:

product_id              warehouse_loc
NX-1233-01             B1-2
                                B2-2            
                                B3-1

Thanks