Pivot Table

[sakthy82]

Hi All ,

I have a large list of matrix with the following format :

USER1 USER2 USER3 USER4
1 N/A N/A 4
N/A 2 N/A N/A
1 N/A 3 N/A
N/A N/A N/A N/A
1 2 N/A
N/A N/A N/A N/A
N/A 2 N/A 4
N/A N/A 3 N/A
N/A N/A N/A 4

I want to have this to a pivot table been trying many ways based on previous forum posting but i was not able to to figure out how to this .

Any guidance much appreciated .

Regards
Sakthy