I am trying to get these results display on columns rather than rows. I found the solution for this but without entering the countif part which makes the results skip duplicate values.
I want the results displayed in cells E10,F10,G10, etc instead of E10,E11,E12, etc

thankstest1.xls