Started by parsing out the Field 1 based on comma delimiter
Used regex to parse out the (\d+) digits only
Replaced F and M with Female and Male
Sorted the data so the year was ascending (starting with 1881) and the frequency was descending (most frequent name)
Used a sample tool to take only the first sex for each year
Filtered the data on female
Joined the anchors of the filter straight into a join so that they would join next to each other based on year
Sorted the data to drop unwanted columns and rename