Hi,
I need to pull a column from a dynamic data source based off one unique id(Math). Can someone help with a formula? I need to pull all names associated with the unique id onto another sheet. In a listed column. Example below:
Data Source:
<tbody>
</tbody>
Desired Outcome:
Math Class:
<tbody>
</tbody>
I need to pull a column from a dynamic data source based off one unique id(Math). Can someone help with a formula? I need to pull all names associated with the unique id onto another sheet. In a listed column. Example below:
Data Source:
Name | Class |
Ron | Math |
Amy | Science |
Zack | Math |
Alicia | Math |
<tbody>
</tbody>
Desired Outcome:
Math Class:
Ron |
Zack |
Alicia |
<tbody>
</tbody>