1 of 1 people found this helpful
If I understand correctly, you want a single list with all of the members from 10 programs sorted by state, right?
This can be done in the Lead Database by creating a new smart list with a Member of Program filter. Define the names of your programs in the filter (you can add 10 by using the green "+" sign) and then you can sort the resulting list by the state column. You could also export the list if you wanted to work with the data in some other program.