Need to automate filling the table

[Belle23p]

Hello! I am trying to make my life easier by completing a table with data. I've tried using pivot but for some reason, I can't seem to get the answer using the required template.

I was hoping to create a table/command that I would only need to put the Batch code (yellow cell) and then the remaining cells will auto populate.

 

[vletm]

Belle23p
Something like this?

 

[Belle23p]

Belle23p
Something like this?

Yes! Thank you. I'll study the formula.