Extracting data from one row across multiple columns to form a lis
 

I've got a worksheet containing the data extracted from an electronic
questionnaire, each set of answers are contained in one column with each
quesion answer on a separate row. I need to find a way of looking up all the
answers from one particular question (i.e. the data from the same row of
multiple columns) and then extracting these in the form of a list without
duplicates. Can anyone help?