Hello,

I hope you can help. I have date imported as such:

Batch Question Answer Text
100 1 Answer
100 2 Answer
100 3 Answer
100 4 Answer


100 5 Answer
100 6 Answer
100 1 Answer
100 2 Answer
100 3 Answer
100 4 Answer
100 5 Answer
100 6 Answer

What I want to do is have the following:
Batch Q1 Q2 Q3 Q4 Q5 Q6
100 Answer Answer Answer Answer Answer Answer

So basically when the question goes back to 1 it then becomes a new record. Is this possible?

Unfortunately I have 919 lines therefore I cannot use the Transpose method within Excel to do this.

Can anyone help! Thank you in advance!