Is it possible to get two series out of a single column?
Hi
Let's say, I have the below columns.
Column Name (example of data)
Year (e.g. 2000, 2001)
Country(e.g. India, China)
Sex (e.g. Male, Female)
Population (Numeric field)
I want to plot two lines, each one to show population of India and China for years 2000 to 2015. Not sure how to achieve this simple-sounding objective because population of all countries, years and sex are in the same column 'Population'.
Thanks for any help.