Transpose data in Access

[Rohit]

I have a table-2 rows by 8 columns in Access. How do I transpose it to 8
columns and 2 rows?

I do NOT wish to use Excel for this. Is there a way to transpose it in
Access itself-using some query/Macro that can perhaps bypass using VB Code?

Any info. is highly appreciated!
Thanks in advance

 

[Doug Robbins - Word MVP]

I doubt that it is possible in the way that you hope and you are unlikely to
get an answer here as this newsgroup is for the use of tables in Word,
nothing to do with access. You should ask your question in the
microsoft.public.access.queries newsgroup.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP