Help with arrays

[dunnobe]

Hi gentlemen,

My first try at writing array code.

I would like to rewrite "transpose" some data.

Prefered end result. -> can also be recreated by running Module2 or the button 'Rework data'!
I would basically need 51624 rows (72 commodities * 717 months) of 5 columns each

Knipsel.JPG

My effort below. I think I (successfully) managed to write down all of the data in arrays, but I have no idea on how to achieve my end result...

Please Login or Register  to view this content.

Module3 holds this erreneous array loops.

Is anyone willing to help me out with Module3?
I would like to speed up my code by using arrays...

Thanks

[Kenneth Hobson]

Please Login or Register  to view this content.

[dunnobe]

Hey @Kenneth Hobson,

Thanks and rep +1.

I did a few checks and made a few changes as the year and month weren't correctly calculated and did a small change to the commodity.

Please Login or Register  to view this content.

Best regards,

Bram

[Norie]

Kenneth beat me to it but I'll post this anyway.

Please Login or Register  to view this content.

[dunnobe]

Thanks norie,

All roads lead to Rome.

Always good to see what the different roads are.