converting pivot table data to summary data

  • Thread starter Thread starter dan graziano
  • Start date Start date
D

dan graziano

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
 
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
 
Back
Top