Hello James,

Select A2:E2 and array-enter:
=TRANSPOSE(Lfreq(A1:E1))

Lfreq is a UDF which you will find he
http://www.sulprobil.com/html/listfreq.html

Regards,
Bernd