How to load HFM data with Year and Period in multiple rows to FCC ?

Summary:

I’m trying to figure out how I can load data from HFM to FCC.

Content (please ensure you mask any confidential information):

The HFM extract comes in this format:

!DATA

Actual; 2025; Jan; YTD; ATE; DKK; 76000; IGE; [None]; [None]; ERP; [None]; -140

Actual; 2025; Feb; YTD; ATE; DKK; 76000; IGE; [None]; [None]; ERP; [None]; -447

Actual; 2025; Mar; YTD; ATE; DKK; 76000; IGE; [None]; [None]; ERP; [None]; -1123

What would be the best approach to have Data Management to look at the second and third column (e.g. 2025: Jan) and transform this into FCC format (FY25; Jan) for multiple columns with Period varying through rows?