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