[ad_1]
\n<\/p>\n
This piece makes it:<\/p>\n
$ awk '{a[$1,$2]=a[$1,$2]$3} END{for (i in a) {print i, a[i]}}' file\nB118791136 x\nA118791136 XxXX\nB23456433 XXx\n<\/code><\/pre>\nJust stores the result in an array, having 1st and 2nd fields as indexes. At the end, it prints the result.<\/p>\n
The result gives B23456433<\/code> instead of B 23456433<\/code>, trying to split it… sed<\/code> makes it:<\/p>\n$ awk '{a[$1,$2]=a[$1,$2]$3} END{for (i in a) {print i, a[i]}}' file | sed 's\/\\([A-Z]\\)\/\\1 \/'\nB 118791136 x\nA 118791136 XxXX\nB 23456433 XXx\n<\/code><\/pre>\nUpdate based on sudo_O’s comment<\/h3>\n$ awk '{a[$1,$2]=a[$1,$2]$3} END{for (i in a) {split(i,b,SUBSEP); print b[1], b[2], a[i]}}' file\nB 118791136 x\nA 118791136 XxXX\nB 23456433 XXx\n<\/code><\/pre>\nUpdate based on new comment<\/h3>\n\n@fedorqui is it possible to add a counter, somehow count the number of
\n the same rows in a column?<\/p>\n<\/blockquote>\n
$ awk '{a[$1,$2]=a[$1,$2]$3} END{for (i in a) {split(i,b,SUBSEP); print b[1], b[2], a[i], length(a[i])}}' file\nB 118791136 x 1\nA 118791136 XxXX 4\nB 23456433 XXx 3\n<\/code><\/pre>\n<\/p><\/div>\n