Shell Programming and Scripting

data_1 american 100
data_1 US 1000
data_1 australia 50
data_2 american 90
data_3 singapore 4
data_3 thailand 50
.
.

data_1 american 100
       US 1000
       australia 50
data_2 american 90
data_3 singapore 4
       thailand 50
.
.

kent$ echo "data_1 american 100
dquote> data_1 US 1000
dquote> data_1 australia 50
dquote> data_2 american 90
dquote> data_3 singapore 4
dquote> data_3 thailand 50"|awk '{if ($1 in a) gsub(/./," ",$1);else a[$1]=1; print $0}'
data_1 american 100
       US 1000
       australia 50
data_2 american 90
data_3 singapore 4
       thailand 50

Data: 

$ cat a2.txt
data_1 american 100
data_1 US 1000
data_1 australia 50
data_2 american 90
data_3 singapore 4
data_3 thailand 50

rm final.txt
##--get unique tags
for i in ` cat a2.txt | awk  '{print $1}'|sort -u`
do
grep $i a2.txt >temp.txt
cat temp.txt | awk '{print $1}'| sort -u > temp2.txt
cat temp.txt | awk '{print $2" "$3 }'> temp3.txt

paste temp2.txt temp3.txt >> final.txt
done
cat final.txt

Output :

$ cat final.txt
data_1  american 100
        US 1000
        australia 50
data_2  american 90
data_3  singapore 4
        thailand 50