Am using Office 2K. I have used Pivot Tables and am still learning more about
it. I have generated a Pivot Table (with about 5000 lines) that shows the
following info:
i.e Acc No 201 was JKB Ltd. The company changed its anme to JKB Sys. We have
kept the same Acc No. It has taken the parts 4737, 4790, 5050, 4532 & 4790.

Acc No Acc Name Part No 3 4 5 Grand Total
201 JKB Ltd 4737 311 311
4790 371 371
5050 293 293
JKB Sys 4532 21 155 90 266
4790 153 330 320 803
355 The C Grp 2000 390 220 255 865
2001 900 440 555 1895
4000 310 160 150 620
PTL Group 2000 224 224
2001 395 395
4000 105 105

Is it possible to get the info in Acc No and Acc Name to be displayed as
follows:
where the Acc No and Acc Name are shown on the screen

Acc No Acc Name Part No 3 4 5 Grand Total
201 JKB Ltd 4737 311 311
201 JKB Ltd 4790 371 371
201 JKB Ltd 5050 293 293
201 JKB Sys 4532 21 155 90 266
201 JKB Sys 4950 153 330 320 803
355 The C Grp 2000 390 220 255 865
355 The C Grp 2001 900 440 555 1895
355 The C Grp 4000 310 160 150 620
355 PTL Group 2000 224 224
355 PTL Group 2001 395 395
355 PTL Group 4000 105 105

Thanks a lot