Thread: Combining the information of several rows into one

Hi everyone,

I have a problem with combining the data of several rows into one.

It's best explained by this example. Suppose you have 3 people fill out a questionnaire with a variable number of questions.

People Questionnumber Answer
1 1 a
1 2 b
1 3 c
1 4 d
2 1 e
2 3 f
2 2 a
3 1 c
3 5 f
3 3 c
3 2 b
3 4 c

Now I would like to have one row per person with in each colomn the answer to a specific question. Because not everyone has answered every question some cell would be blank.

Something like this:
1 2 3 4 5
1 a b c d -
2 e a f - -
3 c b c c f


I really can't figure out how to do this. Pivot tables dont do the trick as I dont need the sum or something,but what is really in the cell. This could also be text.

If someone could help I would appriciated very much!

Thx in advance