Create Calculated Table and replacing empty values, with the "type"

Hello,

unfortunately I got a table which is suboptimal. Here is my sample table:

As you can see in the column "Type" I have many emply or null values. In that case I need a calculated column which always replace all null/empy values with the type which is at least in on of those rows in each ordernumber. 

For example ordernumber 11111 has one row in "Type" which is not empty: "Freight", and also ordernumber 22222 has one row which is not empty : "Box". 

That is the outcome I intend: 

Thank you very much in advance.

Best.