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