Changing multiple columns names

[jure_rak]

Hi all,

I have got data that have 12 columns for months with the abbreviated month name - Jan, Feb, Mar etc. Previously, I just did not bother and manually changed these to be 31.1.2019, 28.2.2019 etc., than did "unpivot columns".

But as I have more and more reports, this manual approach has become inefficient, would you be able to advice me how to automate this process?

Thanks,

[MattAllington · Accepted solution]

Unpivot the columns first, then append “-2019” to the month names, then convert them to dates

[jure_rak]

Got it, -> Add Columns, Format, Add Suffix

[jure_rak]

Sorry for my ignorance, the append "-2019", how could I do it? Still in the editor, I presume, right?