#!/bin/bash
echo "host1,app1
host1,app2
host1,app3
host2,app4
host2,app5
host2,app6
host3,app1" | awk -F, 'NR == 1 { currentHost=$1; currentApps=$2 }
NR > 1 && currentHost == $1 { currentApps=currentApps "," $2 }
NR > 1 && currentHost != $1 { print currentHost ";" currentApps; currentHost=$1; currentApps=$2 }
END { print currentHost ";" currentApps }'
IyEvYmluL2Jhc2gKCgplY2hvICJob3N0MSxhcHAxCmhvc3QxLGFwcDIKaG9zdDEsYXBwMwpob3N0MixhcHA0Cmhvc3QyLGFwcDUKaG9zdDIsYXBwNgpob3N0MyxhcHAxIiB8IGF3ayAtRiwgJ05SID09IDEgeyBjdXJyZW50SG9zdD0kMTsgY3VycmVudEFwcHM9JDIgfSAKICAgICAgICAgTlIgPiAxICYmIGN1cnJlbnRIb3N0ID09ICQxIHsgY3VycmVudEFwcHM9Y3VycmVudEFwcHMgIiwiICQyIH0KICAgICAgICAgTlIgPiAxICYmIGN1cnJlbnRIb3N0ICE9ICQxIHsgcHJpbnQgY3VycmVudEhvc3QgIjsiIGN1cnJlbnRBcHBzOyBjdXJyZW50SG9zdD0kMTsgY3VycmVudEFwcHM9JDIgfQogICAgICAgICBFTkQgeyBwcmludCBjdXJyZW50SG9zdCAiOyIgY3VycmVudEFwcHMgfSc=