N
nullisecundus
Dear All,
This is my first query.
I have been struggling with the following , I have got a pivoted excel sheet
with the following fields for each of 2008 and 2009. ,i.e. I first pivoted
for '08 and then for '09. to get two sets of data.
|customername|grade|total qty.
now I want to make a comparison sheet which should like this
|customer name|grade|total qty. '08|total qty. '09|
As it happens in sales , some customers have added some more grades
vis-a-vis 2008, some customers have not purchased anything in '09 and some
new customers have been added.
IN this consolidated comparative sheet I need to merge the data each for 08
and 09 so that i can arrive at one sheet with all the information without
duplicacy.
trust i have been able to explain the problem, any help would be deeply
appreciated.
TIA,
Nullisecundus.
This is my first query.
I have been struggling with the following , I have got a pivoted excel sheet
with the following fields for each of 2008 and 2009. ,i.e. I first pivoted
for '08 and then for '09. to get two sets of data.
|customername|grade|total qty.
now I want to make a comparison sheet which should like this
|customer name|grade|total qty. '08|total qty. '09|
As it happens in sales , some customers have added some more grades
vis-a-vis 2008, some customers have not purchased anything in '09 and some
new customers have been added.
IN this consolidated comparative sheet I need to merge the data each for 08
and 09 so that i can arrive at one sheet with all the information without
duplicacy.
trust i have been able to explain the problem, any help would be deeply
appreciated.
TIA,
Nullisecundus.