Create a macro or automate a workflow?

[regisb]

Hi! I'm a newbie here. 

I'm trying to create a matrix by downloading several indicators (in this case from the world bank). To create a final file that put it all together, I had to copy and paste the same workflow 8 times, but I'm wondering if there is a way to create a macro that repeats these 6 steps or is there any way to simplify this process? 

Thanks!

[regisb]

Sending the correct packaged file.

Thanks again! 

[Claje]

Hi,

I took advantage of a macro for my proposed solution @BenMoss' Cross Tab Real (with a minor tweak), but that was to handle your column names which include some special characters.  Otherwise, if all your excel files exist in one folder, you should not need any macros to repeat this functionality.  I added my version of the process at the top of the workflow and attached the package here.

Let me know if this helps, and if my solution makes sense!

[regisb]

Could you please send as compatible mode? I don't have the latest version (currently on 11.7) so it's not letting me open the file... 

Thanks! 

[Claje · Accepted solution]

Hi,

I think I correctly updated the new attached file to version 11.7

Let me know if you still encounter issues!

[regisb]

Thank you so much! 

My next goal: study cross-tabs!