How to convert the values in a column in another columns

User: "AlmuVT"
New Altair Community Member
Updated by Jocelyn
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
    User: "MartinLiebig"
    Altair Employee
    Accepted Answer
    Hi,

    have you tried a Split operator and splitted on a whitespace?

    Best,
    Martin
    User: "AlmuVT"
    New Altair Community Member
    OP
    Ah ok, Split operator is what I needed, Thank you!!