Data Table Transformation and Storing

[KLEITH21]

Hello, I am in need of a little help on how to transpose my input form data and write it out to individual file "databases" on a monthly basis. I imagine I need to transform the data structure so that the Current Month kW is the value of the System but I can't quite nail it down!

Incoming data schema

Required Output needs to write to separate files based on Region and then, within those files, tabs based on Site. The Current Month kW would append to the historical readings. It should look something like this unless someone has a suggestion on a better schema.

I tried this but this gives me too many columns for each so maybe I need to summarize and join rather?

[allwynthomas24]

Hey @KLEITH21,

Thanks for accepting the solution.

Regards,

Allwyn.