Returning values from the most common word in order

[Mitzescu]

Hi,
I'm trying to retrun values from the most common word in a column, but in order, wihtout empty cells. I used the INDEX MATCH formula to determine that dog is the most common word, but i don't know i to take them to the 3rd column in order
Column1 Column2 Column3 (the result i want)
dog 7 7
dog 2 2
cat 3 4
dog 4
cat 5
cat 9


Thank you so much if you can help me!
I wish you a great day!

 

[Fluff]

Maybe something like

ZFluff New.xlsm
	A	B	C
1			dog
2	dog	7	7
3	dog	2	2
4	cat	3	4
5	dog	4
6	cat	5
7	cat	9
Grid

Cell Formulas
Range	Formula
C2:C4	C2	=FILTER(B2:B7,A2:A7=C1)
Dynamic array formulas.

 

[Fluff]

If you don't yet have the dynamic arrays.

ZFluff New.xlsm
	A	B	C	D
1			dog
2	dog	7	7	7
3	dog	2	2	2
4	cat	3	4	4
5	dog	4
6	cat	5
7	cat	9
Grid

Cell Formulas
Range	Formula
C2:C4	C2	=FILTER(B2:B7,A2:A7=C1)
D2:D6	D2	=IFERROR(INDEX($B$2:$B$7,AGGREGATE(15,6,(ROW($B$2:$B$7)-ROW($B$2)+1)/($A$2:$A$7=$C$1),ROWS(D$2:D2))),"")
Dynamic array formulas.

 

[Mitzescu]

@Fluff
Wow, Filter works very nice.
Second formula works as well, just the last thing ROWS(D$2:D2))),"") , d2 turns into d3 and so on. But my most common word is not necessarily the first, so i used the INDEX MATCH formula a put it in a cell as a reference.

Anyway. Thank you so much!!

 

[Fluff]

You're welcome & thanks for the feedback