Extract unique values to one row

[Injinia]

Hi,

I need help extracting unique values from a set of data (code 1-code 7) in the sample file. I would like to get just the unique values from the data as shown in the "desired result"

Help much appreciated

 

[bosco_yip]

Try,

In O4, formula copy across and down :

=IFERROR(INDEX($B4:$H4,,MATCH(0,INDEX(COUNTIF($N4:N4,$B4:$H4&""),0),0)),"")

Regards
Bosco