Hello! I am trying to create breakouts from one data source.
<tbody>
</tbody>From this data source, I want to build a new table on another tab using formulas. I would like the table to pull in data from the data source by process (so I will have a table for each process type). So the new table would reference the data source based on process and pull in name and group.
The final tables would look like this:
<tbody>
</tbody>
and
<tbody>
</tbody>
Can anyone help with this??
Thank you!!
Name | Group | Process |
Suzie | A | Emails |
Mark | B | Accounts |
Nicole | A | Emails |
Gus | C | Accounts |
<tbody>
</tbody>
The final tables would look like this:
Name | Group | Process |
Suzie | A | Emails |
Nicole | A | Emails |
<tbody>
</tbody>
and
Name | Group | Process |
Mark | B | Accounts |
Gus | C | Accounts |
<tbody>
</tbody>
Can anyone help with this??
Thank you!!