Suppose I have male and female age in a single column which is a huge dataset. How to split the male and female ages into two different columns?
Example
Sex Age
M 18
F 20
M 65
F 36
M 49
M 27
F 38
Suppose I have male and female age in a single column which is a huge dataset. How to split the male and female ages into two different columns?
Example
Sex Age
M 18
F 20
M 65
F 36
M 49
M 27
F 38