Rendering to Multiple Excels Does not work in my current data format

[nfontenot]

Hi,

I'm having issues figuring out how to get my desired output to split data into multiple Excel files. My issue is my final desired output format is not suitable to render multiple output files by the output path. So I'm including my data before I transposed (Output Data) it to my final format (Transposed Output) and see how I can break split the data by Fund Name/Output Path and then transpose it and render the data. I tried building a macro but I couldn't figure out how to get the multiple Excels to be transposed and then rendered. 

To reiterate - the Output Data is just the data before I transposed it which I think is the format it needs to be to be split by Output Path. The Transposed Output is my desired output format for the multiple excel files.

Thank you!!

[binuacs · Accepted solution]

@nfontenot here is the batch macro which saves output in different excel files based on the fund

[nfontenot]

Thank you!