combone data from more that one page

  • Thread starter Thread starter spencerchicken
  • Start date Start date
S

spencerchicken

what is the easiest way (if possible)to conduct analysis of data from
more than one page
consider I have 5identical pages (one for each sales regions) with lots
of products in column a and months in row 1 with data in a table
is there anyway i can conduct analysis of the 5 sales regions as a
whole or by area
ideally i would like a pivot that had the regions as a field and the
months and products so i can look at the data in anyway poss
 
If you want to create a pivot table from the data, you should store it
all on one sheet, if it won't exceed the available number of rows.

Before you combine the data, to reorganize the data, you may be able to
use the "unpivot' technique described by John Walkenbach:

http://j-walk.com/ss/excel/usertips/tip068.htm

Add a column with the sales region name
Then, copy all the data onto one sheet.
 
Back
Top