How to convert the values in a column in another columns
Hello!
I have a dataset with a column named "months" wich values are "January 2003", "February 2003".... "January 2005"... and again.
And a second column with the number of events in each month-year.
I want to make differents columns corresponding to each year and they will have the value from each moth in that year. So I want a first column with months with values like January, February... and then one column for each year: 2003, 2004...
How can I do it? 
Find more posts tagged with
Sort by:
1 - 2 of
21
Altair EmployeeHi,
have you tried a Split operator and splitted on a whitespace?
Best,
Martin
Ah ok, Split operator is what I needed, Thank you!!
Sort by:
1 - 1 of
11
Altair EmployeeHi,
have you tried a Split operator and splitted on a whitespace?
Best,
Martin