Extracting cell data from a range of columns to form a list

[Guest]

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?

 

[Frank Kabel]

Hi
not sure about your data strucutre but have you tried 'Data - Filter -
Advanced Filter'?

 

[Guest]

No, I cant use Filter as the data I'm wanting to extract is just one row
amongst many and there are no column headers.