Reformat data to vertical format

[Psydwaze]

Here is what I am trying to do.

http://www.totalcontrolproducts.com/totalcontrolproducts_OLD/download/images/Untitled-1.gif

I have about a thousand records that I need in a vertical format with
normal shared field name. Any suggestions

 

[David McRitchie]

see
Creating a Spreadsheet from Database data (#dbdata)
http://www.mvps.org/dmcritchie/excel/snakecol.htm#dbdata

for converting a database type listing with the
field titles in column A and the values in Column B
converted to a spreadsheet format.