Excel - Consolidate data from multiple rows into one row....
Posted on 2004-09-30
Ok, this is what I have. This is an Excel spreadsheet question.
I have 700 rows of data. Within each row is a question of a question set. Also included in each row is the answer to each one of these questions as well as a unique identifier for the question. Since each question sometimes contains multiple answers, in many cases each question is listed multiple times (i.e. a question with four answers will be listed in the spreadsheet four times – the question and the answer.
What I need to do is consolidate the data so each question is listed only once. To do this the corresponding answers will have to be listed in separate cells, in the same row as the question. Without copying and pasting, what can I do to consolidate each answer into the same row as the question it goes with? Remember, each question does contain a unique identifier which I hope helps.