i have this data where a day can have two types of orders as shown in orderty column B2B and B2C and the actual Quantity on Ordnum column. i want to have a column with the order types containing the quantity in each row here is the look on the table
expected outcome
