Transpose Table into excel

[BSando]

Hi All,

I have a table I want to export to excel but i want to transpose the data and remove the field names

from this:
field1 field2 field3
john tim bob

-----------------------
to this:
-----------------------

John
Tim
bob


any help would much be appreciated
Thanks

Some people make things happen, some watch while things happen, and some wonder 'What happened?'

 

[Crowley16]

erm, it's probably easier to import the data from excel rather than export the data to excel because there's not much formatting you can do to format the exports...

however I suppose you can first transpose the data with a query, and then export the query (without titles)...

something like:

SELECT field1 FROM tblName
UNION SELECT field2 FROM tblName
...

Procrastinate Now!