I am parsing below CSV data.

testserver1, Name, BOB
testserver1, Address, ABC Street
testserver1, DEPARTMENT, WIN
testserver1, Gender, Male
testserver1, City, New York
testserver2, Name, Linda
testserver2, Address, EFG Street
testserver2, DEPARTMENT, UNIX
testserver2, Gender, Female
testserver2, City, Bostan

expected result.

“Server”,”Details”
“testserver1″,”Name : BOB; Address : ABC Street; DEPARTMENT : WIN; Gender : Male; City :New York”
“testserver2″,”Name : Linda; Address : EFG Street; DEPARTMENT : UNIX; Gender : Female; City :Bostan”