Help in pivot

[Vijay]

Hi,

I have data like this

A1 A2 A3 A4 B1 B2 B3
xx xxxxx sdsds sdsdsd 12 10 11
df sdsdd dffdd sdsd ds 11 11 11
fgf fgfdgs ggfrtr hhjfdf 14 13 10

i want a pivot table on this like below:

A1 - Team Name
A2 - Task Name
B1 = Wk1 Total
B2 = Wk2 total
......

i want these above in pivot table. all of the above fields on top row. Can
somebody help?

Thanks,
Vijay

 

[Herbert Seidenberg]

Assume your data looks like this:
Team Task Code Wk1 Wk2 Wk3
Ac Cbd A13 3 8 5
Aa Cbd C12 1 4 4
Da Bea C12 7 5 8
Aa Fda C12 9 8 8
Ac Cbd A29 5 1 6
Aa Cbd A13 4 1 7
Ac Bea A13 2 4 8
Aa Fda C12 1 3 6
Ac Cbd A29 2 3 4
Fc Aad E13 3 6 9
Aa Cbd C12 6 6 3
Aa Fda C12 9 5 7
Aa Cbd A13 2 2 7
Ea Fdb C12 9 8 2

Then you can create a Pivot Table to look like this:
(just a small sample)

Team Task Code
Aa Ac
Cbd Fda Bea Cbd
Data A13 C12 C12 A13 A13 A29
SumWk1 6 7 19 2 3 7
SumWk2 3 10 16 4 8 4
SumWk3 14 7 21 8 5 10

You can choose Team, Task or Code to go into
ROW and/or COLUMN. I chose...
Layout: Drag Team, Task and Code into COLUMN
Drag Wk1, Wk2, Wk3 into DATA (Sum of ....)
Options: Uncheck Grand Totals, AutoFormat,
hide subtotals.