Okay, here's an approach:

Use E1 to specify your keyword. Then in C1 you can have this formula:

=IF(A1=$E$1,B1,"")

then copy this down to the bottom of the data in column B by double-clicking the fill handle (the small black square in the bottom right corner of the cursor). Then put this formula in D1:

=IF(C1="","",C1)

and this in D2:

=D1&C2

and copy this down by double-clicking the fill handle. Then in E2 you can have this formula:

=INDEX(D:D,COUNTA(D:D))

which will give you all the matching values from column B in one cell, and the criteria in the cell above it - just change this to get another set.

Hope this helps.

Pete