Dates in columns and variable

[Ludd]

Currently, I have an input like below with hundreds of extra columns:

Country	ID	Initiative	Cost	mar-21	apr-21
UK	1	1	100	30	40
US	2	2	150	12	11
IT	3	2	20	14	11

How can I, without hard coding the current month (mar-21), identify the total per column which would be for UK = 30 and next month = 40? I need to create a new variable for current month.

[Ludd]

Unpivoting does the trick. Thank you!

[lbendlin · Accepted solution]

That is a rather unfortunate table design. Have you considered unpivoting your month columns?