how can i tell excel the data it has is in essence a pivot table

R

Robin Krupp

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
 
D

Debra Dalgleish

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 Data>Text to Columns, Delimited, to split
the data into separate columns.
 
Top