Pivot table for columns

Dinesh, can you try explaining your issue again? Even with the attached document, its a little tough to understand it.

Hi

if you concatenate your 2 coloumns into 1 coloum
then add a 2nd coloum (Alert count) with a value of 1 for each row this will give the out put you want from a pivot table.


example

DeviceMon type Alert count
FW2-EXT-CBTTDIN001-SWEDEN-IPS (172.29.221.4)cpu_usage 1
FSS-A-SMTP-VM1 (172.29.209.141)imss 1
IPS-CBTTOM001-AMSTERDAM-A (172.29.230.2)ping 1

Regards
Lima