I need help converting this table:

Number 1 2 3 4 5 6
196 A C A B D E

Number 1..6 are question no.
196 is the number
A...E are the answers.

I them to be like this:

Number Question Answer
196 1 A
196 2 C
196 3 A
196 4 B
196 5 D
196 6 E

Thanks.