I'm having some issues figuring out if you can create a dynamic list of values in a range, based on separate quantities per item. I have seen it done via VBA, but I'm trying to avoid that if I can.
This is an example of the Data:-
Code Qty
1 Lax 3
2 SF 1
3 Tan 2
4...