In an effort to make it clear, let's assume that Sheet1 contains your
source data...

On Sheet2...

B10, copied across and down:

=IF(ROWS(B$10:B10)<=COUNTIF(Sheet1!$A$1:$A$10,$A$1 0),INDEX(Sheet1!B$1:B$1
0,SMALL(IF(Sheet1!$A$1:$A$10=$A$10,ROW(Sheet1!$A$1 :$A$10)-ROW(Sheet1!$A$1
)+1),ROWS(B$10:B10))),"")

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article ,
Domenic wrote:

Assuming that you're going to enter the formula in B10, try the
following...

B10, copied across and down:

=IF(ROWS(B$10:B10)<=COUNTIF($A$1:$A$10,$A$10),INDE X(B$1:B$10,SMALL(IF($A$
1:$A$10=$A$10,ROW($A$1:$A$10)-ROW($A$1)+1),ROWS(B$10:B10))),"")

...confirmed with CONTROL+SHIFT+ENTER. Make sure that you add the
appropriate workbook and/or sheet names.

Hope this helps!