Q: Creating a table in excel based on column values I have a excel as below:

For each Sales level3 we have a set of "product family" and a set of "country", now I wish to get a output as:

Each country to have all product families against it. Tried with Vlookup/Index/Match, however I was not able to get the desired output, I would need the output for all countries and sales level3
