I have an issue where I am loading from an excel Cross Table and the full headers for columns are stored in two cells in the excel file. The excel file looks like this:
F16
F16
F16
F16
F16
F16
F16
F16
F16
F16
F16
F16
F16
Region
Name
ID
Role
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Total
Europe
John
123
Worker
100
100
100
100
120
120
125
110
115
120
100
110
115
The F16 increments every year so I need to create a column that incorporates the financial year & the month (i.e. F16-Apr, F16-May, etc.)
