Hi,

So my file looks like this:

title number
JR 2
JR 2
JR 4
JR 5
NM 5
NM 8
NM 2
NM 8

I used this line that I wrote to convert it to rows so it will look like this:
awk -F"\t" '!/^$/{a[$1]=a[$1]" "$3} END {for ( i in a) {print i,a[i]}}' occ_output.tab > test.txt

JR 2 2 4 5
NM 5 8 2 8

The problem is that the spacing is not tab delimited. I am missing something really obvious...

The next thing I want to do is bin the rows... lets say I wanted to bin every second value and average them.

so it will look like this:

JR 2 4.5
NM 6.5 5

Anyone know a quick liner on how to do that?

thanks