Hi,
I have a sheet of employees
Employee ID
Name
and another with tasks
Task ID
Employee ID
Task
Is there a way to automatically create an inner join table on a separate sheet with these fields, using Employee ID as the joining field? This table should update itself any time there’s an entry on any of the tasks table.
Employee ID | Name | Task