Copy and paste to one row based on matching values

Then lets try this two formula solution. The first column, E, is populated by the formula:

Formula:

=IF(B2=B1,"",IF(AND(A3="Y",B3=B2),D3,""))

Subsequent columns are populated by the formula:

Formula:

=IF(E2="","",IF(AND(INDEX($A$1:$A$20,ROW()+MATCH(E2,$D3:$D$20,0)+1)="Y",INDEX($B$1:$B$20,ROW()+MATCH(E2,$D3:$D$20,0)+1)=$B2),INDEX($D$1:$D$20,ROW()+MATCH(E2,$D3:$D$20,0)+1),""))

Let us know if you have any questions.