Reformat data to vertical format

Here is what I am trying to do.

http://www.totalcontrolproducts.com/...Untitled-1.gif

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

see
Creating a Spreadsheet from Database data (#dbdata)
http://www.mvps.org/dmcritchie/excel...col.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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Psydwaze" <Psydwaze.1qq8ec_1118937917.5963@excelforum-nospam.com> wrote in message
news:Psydwaze.1qq8ec_1118937917.5963@excelforum-nospam.com...
>
> Here is what I am trying to do.
>
> http://www.totalcontrolproducts.com/...Untitled-1.gif
>
> I have about a thousand records that I need in a vertical format with a
> normal shared field name. Any suggestions.
>
>
> --
> Psydwaze
> ------------------------------------------------------------------------
> Psydwaze's Profile: http://www.excelforum.com/member.php...o&userid=24371
> View this thread: http://www.excelforum.com/showthread...hreadid=379655
>