Populate a list from a table

[erice]

Hello,

I am trying to create a tool that can be used to schedule a sequence to process orders. At the start of the day we will be given a table (A3:C7) with the Item description and Quantity needed that day. I am looking to then generate a list (A11:A22) that contains the correct quantities of each item in the table. For example B2 shows that I need to produce quantity 2 of Item 1, so the list (A11:A22) needs to contain quantity 2 of Item 1. In my actual dataset there will be a different number of items each day that I need to accommodate for.

Image 1.PNG

Thank you

[sandy666]

with Power Query

[sandy666]

You are welcome and thanks

[erice]

Thank you sandy666, that solutions does work.

[sandy666]

My pleasure