Search results

Yes, that's exactly what I want.

Yes, so in essence I have a colum with all of my stores in and a column with all of my products in. I need excel to then convert it into a long list with each store and all of the products against it.

I have to do an order with a supplier, I have a list of products I need to order and I have a list of stores I need to order the products for but I need a consolidated list of all products against each store. Is there a quick way to do this with formula rather than manually copying and pasting...