multiple values in column

[bigproblem]

I can use
=INDEX($B$1:$B$30,SMALL(IF($A$1:$A$30=$C$1,ROW($A$1:$A$30)),ROW(A1))) to get
the multiple column values but is there a way so that the return value is
returned in the same row i.e. d1, e1, f1 not d1, d2, d3.

 

[Teethless mama]

=INDEX($B$1:$B$30,SMALL(IF($A$1:$A$30=$C$1,ROW($A$1:$A$30)),COLUMNS($D)))

ctrl+shift+enter, not just enter
copy across

 

[bigproblem]

You rock !!! Thank you, you saved me a lot of time !!!