Categorizing Data by period

[YH_IKONS]

Hi

I have a spreadsheet which has repeated column of data which refer to different periods as shown in the screenshot. These periods are defined in a separate table. 
How to I split these field headers in order to associate the data with the relevant fields?

Regards
Daanyaal