making stem and leaf back to back diagram

hello.

here is a similar problem to the one i have to do as an assignment. that data table includes 400+ students.

marks Gender
65 F
53 M
66 F
75 F
72 F
92 M
55 F
69 F

i have to draw a back-to-back stem and leaf diagram, placing Male and Female at two sides. How can I do that in excel? i think first i have to rearrange the data set. dont know how. help.