columns to rows

[Ed]

Brenda,

I don't think you do it in Excel.
What I would do is import the data in the existing format
to Access.
Create a table in Access with the format that you want.
Then for each Heading, create an append querry to append
the data.
Then you can export the data back to Excel.