Forum Discussion
Create a new table separating managers from a larger employees database table with select columns
Hello, I hope someone could help. I have a massive table of employee data with hundreds of data points on one sheet. I want to create a new table on a new sheet which has just a few data points...
Let's say the table is named Employees.
On the other sheet, enter the following formula in A1:
=VSTACK(Employees[#Headers],FILTER(Employees, (Employees[Manager Status]="Manager")+(Employees[Manager Status]="People Manager"), ""))
