"Ron Coderre" wrote...
With your posted data in A1:B9

Try this:
D1: (the Col_A item to match)

Put this ARRAY FORMULA (committed with Ctrl+Shift+Enter, instead fo just
Enter) in
E1:
=IF(ROW()COUNTIF($A$1:$A$10,$D$1),"",INDEX($B$1: $B$10,
SMALL(IF($A$1:$A$10=$D$1,ROW($A$1:$A$10)),ROW())) )
....
Adjust range references to suit your situation.
....

Not the ideal formula. ROW() as such will return the row of the cell
containing the formula containing the ROW() call. If the OP entered this
formula in E11 and below, it'd always return "". Always better to be more
specific with rows so formulas would work no matter where they're placed.

=IF(ROWS(E$1:E1)COUNTIF($A$1:$A$10,$D$1),"",INDEX ($B$1:$B$10,
SMALL(IF($A$1:$A$10=$D$1,ROW($A$1:$A$10)-MIN(ROW($A$1:$A$10))+1),
ROWS(E$1:E1))))

or

=IF(ROWS(E$1:E1)COUNTIF($A$1:$A$10,$D$1),"",INDEX ($B:$B,
SMALL(IF($A$1:$A$10=$D$1,ROW($A$1:$A$10)),ROWS(E$1 :E1))))

Former, though longer, is better because it limits its references to the
ranges containing data.