Formula to fetch multiple orders from same customer

[natimich]

I want to fetch different orders from each customer in a table as attahed below. Some customers may have multiple orders, thus I want to fetch the customer name, each order ignoring the blanks

I want to extract the above table as below

I need a formula or combination of formulas to do this
Thnaks

 

[Fluff]

Hi & welcome to MrExcel.
You can use the filter function for that, like

=FILTER(B2:C1000,B2:B1000<>"")

 

[natimich]

Hi & welcome to MrExcel.
You can use the filter function for that, like

=FILTER(B2:C1000,B2:B1000<>"")

Thanks but it keeps bringing the first order for same customer name again

 

[Fluff]

Just put the formula in one cell & do NOT use Ctrl Shift Enter