move genders into own columns
$ intsv=table8_bahasaindonesiaEnglish.tsv; m=$(grep -E "^Male" $intsv|cut -f1 --complement); f=$(grep -E "^Female" $intsv|cut -f1 --complement); mf=$( paste -d'\t' <(echo "$m") <(echo "$f") ); rows=$( cat $intsv | cut -f1| grep -vE "^(Male|Female)"|sed '1d' ); header=$( cat $intsv | head -n 1 ); echo "$header"| cat - <( paste -d'\t' <( echo "$rows" ) <(echo "$mf") ) > table8.tsv
for both tables
appropriate headers - had to add again for female
change headers
explain headers