Help! Excel formula - Pulling from data to another sheet

[Shetara]

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:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name [/TD]
[TD]Category [/TD]
[/TR]
[TR]
[TD]Birtha[/TD]
[TD]Art Class[/TD]
[/TR]
[TR]
[TD]Garry[/TD]
[TD]Math Class[/TD]
[/TR]
[TR]
[TD]Ren[/TD]
[TD]Art Class[/TD]
[/TR]
</tbody>[/TABLE]

 

[Aryatect]

Hi, This is 1 option:

Taking more details from https://www.mrexcel.com/forum/excel-questions/1107193-simple-formula-excel.html

Book1
	A	B
1	Data Source:
2	Name	Class
3	Ron	Math
4	Amy	Science
5	Zack	Math
6	Alicia	Math
7
8
9	Desired Outcome:
10	Class:	Math
11
12	Ron
13	Zack
14	Alicia
15
16
17
Sheet3

Cell Formulas
Range	Formula
A12	=IFERROR(INDEX($A$3:$A$6,AGGREGATE(15,6,(ROW($A$3:$A$6)-ROW($A$3)+1)/($B$3:$B$6=$B$10),ROWS(A$12:A12))),"")