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!