Hello,
I have a table countries and jobs in that country. I am looking to select the job and get all the countries that job is in. Example: select Janitor and the output will show USA,China and Canada
<tbody>
</tbody>
Is this something excel can do or is this something only access can process?
Thank you for your help.
Rosa
I have a table countries and jobs in that country. I am looking to select the job and get all the countries that job is in. Example: select Janitor and the output will show USA,China and Canada
USA | Spain | China | Canada | Mexico |
Janitor | Payroll | Janitor | HR | Manager |
Operator | Payroll | Janitor | ||
Manager2 | DVP | |||
HR |
<tbody>
</tbody>
Is this something excel can do or is this something only access can process?
Thank you for your help.
Rosa