dynamic arrays

ShimonGeiman Not sure I get your point, but have attached a slightly revised file where the lists for the dropdowns are now transposed and on to the same row as the item description for each of the categories chosen. Added an extra product to demonstrate what I was thinking of. For the next product, just copy the table and the formulae in N to where ever you want to have your next product. 

If this is not what you had in mind, please show an example of how your sheet with 60-70 products really looks like.