Shell Programming and Scripting

Hi All,

I am trying to work on below text

a b c 1
a b c 2
a b c 3
x y z 6
x y z 44
a b c 89

Need to delete the occurances and get in single line like below:

a b c 1 2 3 89
x y z 6 44 89

Please help me i am new into unix scripting .....

---------- Post updated at 03:00 PM ---------- Previous update was at 02:55 PM ----------

Even when i try using a xcel pivot table to do this also doesnt help as output is something like this
abc 1
2
3
89
Xyz 6
44
89

Not getting in same row.......

How to use awk to get this

Code:

awk '/a b c/ {t=t" "$4} /x y z/ {s=s" "$4} END {print "a b c" t;print "x y z" s}' inputfile

Hey thanks but this is for only xyz and abc but my data file is huge with different patterns occuring many times....

Code:

 
awk '{ a[$1" "$2" "$3" "]=a[$1" "$2" "$3" "]" "$4}END { for(i in a) print i,a[i]}' input_file.txt

Check if this meets ur requirement...

Code:

/bin/sort inputfile | awk ' BEGIN { FS=OFS=" ";getline;prev=$1" "$2" "$3;s=$4 }

{
  curr=$1" "$2" "$3
#  print curr
  if ( prev == curr )
    s=s" "$4
  if ( prev != curr )
   {
   print prev " " s
   prev=curr;s=$4
   }
}
END {
   print prev " " s
}'

panyam's solution is cool and exact..

why does "x y z" has an extra 89?

Looks typo to me.