Hi,
I have a formula which Bo_Ry kindly helped me with
it works perfect in 365 but I need it to work in 2016 can anyone help.

=TRANSPOSE(UNIQUE(H2:H100))