Arrange / format data using awk

Shell Programming and Scripting
1

Input

 
217:fngadi4osa:fngadi4osa:M 217:415744:N/A
227:fngadi4osa:fngadi4osa: M 227:51200:N/A
228:fngadi4osa:fngadi4osa: M 228:102400:N/A
65:sapgt04:sapgt04: M 65:104448:N/A
228:fngadi4osa:fngadi4oma: M 228:102400:N/A

Output

 
217:fngadi4osa:fngadi4osa:M 217:415744:N/A
227:fngadi4osa:fngadi4osa: M 227:51200:N/A
228:fngadi4osa:fngadi4osa: M 228:102400:N/A
228:fngadi4osa:fngadi4oma: M 228:102400:N/A
 
65:sapgt04:sapgt04: M 65:104448:N/A

Basically i want to arrange/couple data by a column x .. say in this case its column 3 and have a space between each set -- thx

2

Try:

sort -t: -k3 infile | awk -F: '!a[$3]++{printf "\n"}1'
3 
awk -F: '{a[$3]=a[$3]==0?$0:a[$3] RS $0}END{for(i in a) print a RS}' file
4

Thank u guys ... Works !!