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

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