To reorganize the data, you can use the technique described here by John
Walkenbach:

http://j-walk.com/ss/excel/usertips/tip068.htm

If you have multiple label columns, you should concatenate them before
using the above technique. For example, insert a blank column after
Product Name, with a heading, and the formula:

=A2 & "$" & B2

After using the technique, use DataText to Columns, Delimited, to split
the data into separate columns.


Robin Krupp wrote:
i have data in a pivot table form put not defined as a pivot table
i would like to be able to have excel transpose the data into record form

if any one has suggestions and wants sample data please reply


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html