Simple Formula in Excel?

[Shetara]

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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Class[/TD]
[/TR]
[TR]
[TD]Ron
[/TD]
[TD]Math[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]Science[/TD]
[/TR]
[TR]
[TD]Zack[/TD]
[TD]Math
[/TD]
[/TR]
[TR]
[TD]Alicia[/TD]
[TD]Math [/TD]
[/TR]
</tbody>[/TABLE]

Desired Outcome:

Math Class:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Ron
[/TD]
[/TR]
[TR]
[TD]Zack[/TD]
[/TR]
[TR]
[TD]Alicia[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel...excel-formula-pulling-data-another-sheet.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.