Transpose data in a table

[sgrobben]

I have a table that looks like this:

StorageID	Question	Answer
1	A	1A
1	B	1B
1	C	1C
2	A	2A
2	D	2D

I want to transpose this data so that the table would look like this:

StorageID	A	B	C	D
1	1A	1B	1C
2	2A			2D

Is this possible and so yes, how would i do this?

Thanks in advance!

[anat · Accepted solution]

u can use Generic load