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

V

vakant

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting data from one row across multiple columns 1
batch extract all tables from multiple word documents 1
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Extracting data from Multiple columns to a Single row 3
Extracting records from a list 1
Extracting data from one row across multiple columns to produce a list 5
When extracting from column A no data 4
Help with Sumproduct searching cell contents 2

Top