Combine columns with the same header in one file

UNIX for Beginners Q & A
1

Hello I'm looking to take one file that has multiple lines and columns and add (sum) the values horizontally of columns with repeated headers. In my file, I'm ignoring the first 9 columns and the first row because I want them to be printed in the outcome, untouched. (the columns are not in a repeating order and there are many more columns than the example). The idea is something like this:

Input:

var x y x y x y
a 1 0 1 1 0 1
b 1 1 0 0 1 1
c 1 1 0 0 0 0

Output:

var x y
a 2 2
b 2 2
c 1 1

Here's what I've got so far....

awk -F '\t' '{FS==OFS} FNR==1; FNR>1 {for (i=10; i<=NF; i++) {} print}' FILE.tsv > FILE_norepcols.tsv
2 
awk -F '\t' '
NR==1 {
for (i=2; i<=NF; i++) {c=$i; cs[$i]=$i;}
printf $1 FS;
for (i in cs) printf i FS;
print "";
next;
}
{
for (i in cst) delete cst;
for (i=2; i<=NF; i++) cst[c]+=$i;
printf $1 FS;
for (i in cs) printf cst FS;
print "";
}
' FILE.tsv
3

Hi

awk 'NR==1 {NF=3; print; next}; {for (i=2; i<NF; i+=2) {one+=$i; two+=$(i+1)}; print $1, one, two; one=two=0}'

you can skip as many as you need i=10

--- Post updated at 19:55 ---

awk 'NR==1 {NF=11; print; next}; {for (i=10; i<NF; i+=2) {one+=$i; two+=$(i+1)}; NF=9; print $0, one, two; one=two=0}'