Creating a Bill Of Material

Can somebody help me please? How would you create a bill of material in excel with the data attached?

Read the Guides:
https://www.manager.io/guides/7767
https://www.manager.io/guides/9572