adding new rows on source sheet

Originally Posted by oeldere

Advice

1) Don't work with merged cells, you get in trouble with it, sooner or later

2) Make an helpcolumn to determine if the student is a boy or a girl.

After that you can analyse the data with an pivot table.

I Already unmerged the cells, thanks for that...

I wish I could play with the SOURCE sheet to place helper columns for it, however, I couldn't because the source sheet did not come from me.