What is the easiest way to convert in excel very large amounts of data
made for pivot tables (one data value per line) back to a summary table
form?

For example, from:

salesman region year value
joe russia 1998 350
joe russia 1997 700
joe russia 1999 299
joe russia 2000 5000
mary asia 1997 790
mary asia 1998 250
mary asia 2000 799

to the cross-tabulated form:

salesman region 1997 1998 1999 2000
joe russia 700 350 299 5000
mary asia 790 250 799

Thank you for your suggestions.

Dan Graziano



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Create a pivot table from the data, with Salesman and Region in the row
area, year in the column area, and value in the data area.

Turn off subtotals and totals.

Copy the pivot table, and paste onto another sheet, as values.

To fill the headings down to each row, use one of the techniques shown here:

http://www.contextures.com/xlDataEntry02.html

dan graziano wrote:
> What is the easiest way to convert in excel very large amounts of data
> made for pivot tables (one data value per line) back to a summary table
> form?
>
> For example, from:
>
> salesman region year value
> joe russia 1998 350
> joe russia 1997 700
> joe russia 1999 299
> joe russia 2000 5000
> mary asia 1997 790
> mary asia 1998 250
> mary asia 2000 799
>
> to the cross-tabulated form:
>
> salesman region 1997 1998 1999 2000
> joe russia 700 350 299 5000
> mary asia 790 250 799
>
> Thank you for your suggestions.
>
> Dan Graziano
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!


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