Creating Header Name form 2 excel rows

[ciaran_mcgowan]

Hi all,

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.)

Any thoughts?