This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I used the text to columns to split out the first field, then used Regex to parse out the 4 digit year from the filename using \d\d\d\d. I then grouped the records by year and gender to find the maximum frequency and joined back on these fields to the main stream. Then I simply split by gender and joined on the year.