I have a lookup file, which is of the format:
"Department", "Jan FY20", "Feb FY20", "Mar FY20", "Apr FY20"
"Sales", "12", "15", "18", "17"
"HR", "7", "5", "6", "11"
Over time, the number of columns will increase, and their names may change, but they will always contain "FY".
What I want to do is return the data in the form:
department_name, month_name, value
I.e.
Sales, Jan FY20, 12
Sales, Feb FY20, 15
Sales, Mar FY20, 18
Sales, Apr FY20, 17
HR, Jan FY20, 7
HR, Feb FY20, 5
HR, Mar FY20, 6
HR, Apr FY20, 11
I'm sure that there's a simple function to do this (at search time), but I can't work it out.
What is the best way to do this?
... View more