filter and transpose into multiple separate files

[TiffanyH12]

I have a data set where I first filter by a column "Region". Then each region needs to be crosstab to get the data the way I want it and then exported to an excel file. I need a file for each region (10+ files at the end). 

What I have:

Account #	Account Name	CoCode	Value	Region
1000	xxx	1-france	$$	France
1200	xxx	1-France	$$	France
1300	xxx	2-France	$$	France
1400	xxx	6-France	$$	France
1200	xxx	3-Germany	$$	Germany
1300	xxx	3-Germany	$$	Germany

What I want:

I want my output file to look like this but have the workflow produce separate output files for all the different regions. Is there a way to build this in the workflow to complete this process without having to build duplicates of the process in the workflow over and over for all the regions I have?

Account #	Account Name	1-France	2-France	6-France
1000	xxx	$	$	$
1200	xxx	$	$	$
1300	xxx	$	$	$
1400	xxx	$	$	$

[echuong1]

This is possible with a batch macro. I've done the transpose with a cross-tab inside of the macro.

For the actual workflow, I've created a unique list of the regions, since that is what I want my batches to iterate by. You can see that the macro runs twice, once for each region.

[TiffanyH12]

Thanks for the response! Are you able to share the marco and workflow in separate files? I can't open the package for some reason. 

[echuong1]

See attached! You'll need to reconfigure the macro after adding it back.