Hello,
I want to pull names connected to a category. I need help pulling all names associated with this category. The name column also grows throughout the year. Is there a formula to use that will pull all names associated to the column?
OR Can I make a pivot table and then extract the names aligned to the category to a new excel sheet?
Example:
<tbody>
</tbody>
I want to pull names connected to a category. I need help pulling all names associated with this category. The name column also grows throughout the year. Is there a formula to use that will pull all names associated to the column?
OR Can I make a pivot table and then extract the names aligned to the category to a new excel sheet?
Example:
Name | Category |
Birtha | Art Class |
Garry | Math Class |
Ren | Art Class |
<tbody>
</tbody>