Excel 2002: Can Pivot Table show headings beside the row labels ?
Dear Sir
Lets consider the following raw data
Raw Data
Staff Code Month Amount
Jim K1 1 200
Betty K2 1 400
Kim K3 2 500
Tom K4 3 350
Pat K5 4 220
If I take the Staff Code as my roe label and Month as my column label when
creating a Pivot Table, I would get a table as illustrated below:
Pivot Table
Code 1 2 3 4
K1 xxx xxx
K2 xxx
K3
K4
K5
Is there a way for me to show the staff name at the left of the staff code
while creating the Pivot Table ?
At present, I am using the VLOOKUP formula to fill up this data.
Thanks
Low
--
A36B58K641
|