Create a Union query on your table.

The query should look something like:

SELECT Number, 1 As Question, [1] As Answer
FROM MyTable
UNION
SELECT Number, 2 As Question, [2] As Answer
FROM MyTable
UNION
SELECT Number, 3 As Question, [3] As Answer
FROM MyTable
UNION
SELECT Number, 4 As Question, [4] As Answer
FROM MyTable
UNION
SELECT Number, 5 As Question, [5] As Answer
FROM MyTable
UNION
SELECT Number, 6 As Question, [6] As Answer
FROM MyTable

Save that query, then use it as the source for a MakeTable query.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"psinta" wrote in message
...
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.