Filter out State in Report

[JillStiart1234]

Hello, 

I would like a routine to take the report attached and filter out each state into a different tab.

Can you assist?

[jrgo]

@JillStiart1234 

Play with these options at the bottom of your Output tool

Using the option "Change File/Table Name", as pictured, will do exactly what you described.

[Tyro_abc]

Hi

Try this...

The output looks like..

 Best Regards

Arundhuti

[MatthewBr]

Take a look at the attached batch macro.  You will have to make some minor modifications to get the fields in the columns and rows to be in the order you want.

[JillStiart1234]

I like this routine. The only issue is that there are zero values. For instance, CA has PTBI values but after the macro it's 0.

[JillStiart1234]

I think the macro only has "AK" filtered out. Is there anyway to include all states so they have values? Thank you so so so much in advance! 

[jrgo]

@JillStiart1234 

I had originally responded before looking at your input file you shared. 

See attached... hope this helps you out.

-Jimmy