is it possible through pivot table

[leovincent]

I have this format

SL.NO PROJECT NO EMP ID NAME DESIGNATION AMOUNT EMP ID NAME DESIGNATION AMOUNT EMP ID NAME DESIGNATION AMOUNT
1 ABC101 101 Ramkumar. S Manager 1500 115 Kumar. A Asst. Manager 7500 111 Senthil. R Asst. Manager 15000
2 ABC105 111 Senthil. R Asst. Manager 7500 101 Ramkumar. S Manager 2500 115 Kumar. A Asst. Manager 6000
3 ABC109 115 Kumar. A Asst. Manager 6300 111 Senthil. R Asst. Manager 25000 101 Ramkumar. S Manager 5000
4 ABC110 119 Praveen. P Asst. 9600 111 Senthil. R Asst. Manager 15000 115 Kumar. A Asst. Manager 7500
5 ABC130 120 Raja. R Asst. 9000 119 Praveen. P Asst. 9600 111 Senthil. R Asst. Manager 65000



I need this below format without manual entry.

EMP ID NAME DESIGNATION ABC101 ABC105 ABC109 ABC110 ABC130 TOTAL
101 Ramkumar. S Manager 1500 2500 5000 9000
115 Kumar. A Asst. Manager 7500 6000 6300 7500 27300
111 Senthil. R Asst. Manager 15000 7500 25000 15000 65000 127500
119 Praveen. P Asst. 9600 9600 19200
120 Raja. R Asst. 9000 9000
TOTAL 24000 16000 36300 32100 83600 192000

Is it possible to solve through pivot table?

[arlu1201]

Pivot tables may not be able to assist you. A VBA code might.