Hi,
I've been unable to find that answer to this, but this could be partly because I don't really know what it would be called.
I have 2 columns of data and I want to pair them.
Sheet 1 has a long list of part numbers/product codes. Sheet 2 has 3 customer types.
I would like to publish into Sheet 3 every unique combination of these two value. Eg:
Product 1 Customer 1 Product 1 Customer 2 Product 1 Customer 3 Product 2 Customer 1 Product 2 Customer 2 etc etc
Bookmarks