EXCEL fORMULA|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi

Can you please assist me if possible with a excel formula I can use for the attached list to insert the yellow highlighted items to be dragged until end of the row of each recipe to the left side of the recipe and the total mass be aligned in right column on top.
Here is the example of what I want below: The item code is 31124B

31124B Tasty Nation Budget Burger Patty (Mix-Cook)
Ham Mixing Loss
Input
ZZZ999 Water 1 501.50
XXX903 MDM * 1 396.50
SPIC023 Tasty Nation Burger Spice Pack 473.00
ZZZ535 Burger Patty Offcut 212.89
XXX919 Beef Body Fat * 137.86

3 721.75 100.00% ###### -210.01

31124B Tasty Nation Budget Burger Patty (Mix-Cook) 3 721.75
31124B ZZZ999 Water 1 501.50
31124B XXX903 MDM * 1 396.50
31124B SPIC023 Tasty Nation Burger Spice Pack 473.00
31124B ZZZ535 Burger Patty Offcut 212.89
31124B XXX919 Beef Body Fat * 137.86