Assuming the column containing Brown is 'Data'!A2:A20 and 2340, 2475
are in 'Data'!B2:B20, then, in your target sheet you can use the
following:

in A2:

='Data'!A2

In A3 the *array* formula (enter with Shift+Ctrl+Enter):

=IF(ISNUMBER(MATCH(1,--(COUNTIF(A$2:A2,Data!A$2:A$20)=0),0)),INDEX(Data!A $2:A$20,MATCH(1,--(COUNTIF(A$2:A2,Data!A$2:A$20)=0),0)),"")

This column will be copied down far enough until you get spaces. It
will give you the collection of unique entries found in the input.

In B2 *array* formula:

=INDEX(Data!$B$2:$B$20,MATCH(1,--(Data!$A$2:$A$20=A2),0))

Copy down. It will give the first occurrence of each code.

In C2 *Array* formula:

=IF(ISNUMBER(MATCH(1,--(Data!$A$2:$A$20=$A2)*(COUNTIF($B2:B2,Data!$B$2:$B $20)=0),0)),INDEX(Data!$B$2:$B$20,MATCH(1,--(Data!$A$2:$A$20=$A2)*(COUNTIF($B2:B2,Data!$B$2:$B $20)=0),0)),"")

Copy down and across as necessary.

HTH
Kostis Vezerides