Hi All -
I have a issue that I don't seem to know how to get around. I have a list of over 200K zip codes with 64 personas that live in the zip codes. I'm trying to run a pivot table to understand what personas and how many of each of those personas roll into each zip code, however, a pivot table doesn't seem to work for this exercise as each persona is in different columns.
Is there a way to do this? I've attached a sample data set. forum.ozgrid.com/index.php?attachment/59334/
Your help would be appreciated!