Hi, I am having trouble sorting out this data, I need to sort it out according to the table and the value in the table should be counted as number "1".
In the first row, the column 4&5 was supposed to be merged but I can't do it here
same with 6&7, 8&9.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]DATA[/TD]
[TD]DATA[/TD]
[TD]DATA[/TD]
[TD]Less than 1 year[/TD]
[TD][/TD]
[TD]1 to less than 2 years[/TD]
[TD][/TD]
[TD]2 to less than 5 years[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GENDER[/TD]
[TD]AGE[/TD]
[TD]AGE GROUP[/TD]
[TD]MALE[/TD]
[TD]FEMALE[/TD]
[TD]MALE[/TD]
[TD]FEMALE[/TD]
[TD]MALE[/TD]
[TD]FEMALE[/TD]
[/TR]
[TR]
[TD]M[/TD]
[TD]1[/TD]
[TD]1 to less than 2 years[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]5[/TD]
[TD]2 to less than 5 years[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]0[/TD]
[TD]less than 1 year[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]M[/TD]
[TD]3[/TD]
[TD]2 to less than 5 years[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]2[/TD]
[TD]2 to less than 5 years[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]M[/TD]
[TD]0[/TD]
[TD]less than 1 year[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]1[/TD]
[TD]1 to less than 2 years[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
In the first row, the column 4&5 was supposed to be merged but I can't do it here


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]DATA[/TD]
[TD]DATA[/TD]
[TD]DATA[/TD]
[TD]Less than 1 year[/TD]
[TD][/TD]
[TD]1 to less than 2 years[/TD]
[TD][/TD]
[TD]2 to less than 5 years[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GENDER[/TD]
[TD]AGE[/TD]
[TD]AGE GROUP[/TD]
[TD]MALE[/TD]
[TD]FEMALE[/TD]
[TD]MALE[/TD]
[TD]FEMALE[/TD]
[TD]MALE[/TD]
[TD]FEMALE[/TD]
[/TR]
[TR]
[TD]M[/TD]
[TD]1[/TD]
[TD]1 to less than 2 years[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]5[/TD]
[TD]2 to less than 5 years[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]0[/TD]
[TD]less than 1 year[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]M[/TD]
[TD]3[/TD]
[TD]2 to less than 5 years[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]2[/TD]
[TD]2 to less than 5 years[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]M[/TD]
[TD]0[/TD]
[TD]less than 1 year[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]1[/TD]
[TD]1 to less than 2 years[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]