Please Help! Microsoft excel question

so I'm new to excell and I have over 400 entries to analyze. I'm trying to figure out a way to split the groups in different demographics rather than the manual control and paste. For instance, I want to split up men and women who were surveyed..how do I do this?

You might get more help posting this in PC hardware section theres alot of software questions posted there also.