Vertical to Horizontal Extract Unique Values with Sorting By Formula

[AVK]

I have data in "H" column (in vertical).
I required those data horizontal form "Q2:V2", Extract Unique values with sorting.
I have attach sample file for your ref.

 

[bosco_yip]

Try,

Q2, formula copy right :

=IFERROR(SMALL($H$2:$H$18,COUNTIF($H$2:$H$18,"<="&P2)+1),"")
Regards

Bosco

 

[AVK]

Thanks works perfectly.