Merging Year from column into X Axis with Months

[SGood]

Hi,

I am importing from an excel spreadsheet, into #QlikView.  Along with a number of other columns, the table contains the following structure, with the Allocation year in a separate column from the months:

BP ID	Allocation Year	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
8882	2020	0	0	0	0.85	0.85	0.85	0.85	0.85	0.85	0.85	0.85	0.85
10037	2021	0	0	0	0	0	0	0	0	0	0	0	0.4
10037	2022	0.4	0.4	0.4	0.4	0.4	0.4	0.4	0.4	0.4	0.4	0.4	0.4
10054	2022	1	1	1	1	1	1	1	1	0	0	0	0
10603	2020	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15
10603	2021	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15
10603	2022	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15

However, I need the year merged in with the month columns, to output like this:

BP ID	Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20	Sep-20	Oct-20	Nov-20	Dec-20	Jan-21	Feb-21	Mar-21	Apr-21	May-21
8882	0	0	0	0.85	0.85	0.85	0.85	0.85	0.85	0.85	0.85	0.85	0.85	0.85	0.85	0.85	0.85
10037	0	0	0	0	0	0	0	0	0	0	0	0.4	0.4	0.4	0.4	0.4	0.4
10037	0.4	0.4	0.4	0.4	0.4	0.4	0.4	0.4	0.4	0.4	0.4	0.4	0.4	0.4	0.4	0.4	0.4
10054	1	1	1	1	1	1	1	1	0	0	0	0	1	2	3	4	5
10603	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15
10603	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15
10603	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15	0.15

Any suggestions on how to create script to load the data into this structure would be greatly appreciated.

Thank you.

Sally

[SGood]

Ah, don't know why I didn't try this earlier.  I have limited the load to 10 and it's now running.  So, I guess it has something to do with the volume of data.

[SGood]

Thanks Steve, managed to get it working properly.  Greatly appreciate all the help you provided.  🙂

Kind regards.

Sally