Hello,

I am stragling for some time now with workbooks I need to merge into one searchable spreadsheet.
Here is what I have:
Names and data associated with it is partly at name level while other bits are by country.

I need to be able to search by country and see all the info. that is on name level as well as that country's level

So if I have company X there will be categories & activities columns that are at name level than come countries contact and address that are at country level.
When I filter by country and category I need to see the name, the activity as well as contact and address for that specific country.

All I am looking for is the right layout to be able to use filters and still see all the info
I don't know if I was clear enough so open to questions and suggestions.
The list is few thousand names long