This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I need some help. In this attached file you can see, there is are four columns named as SC Allocate, CA Allocate, WA Allocate and OR Allocate. I am just wondering is there any way I can move this data to SC, CA, WA, and OR without using a separate column for each of them.
Here's another approach, which is a total cheat/hack. After transposing all of the state and allocated columns, use a Select tool, changing the length of the Name column to 2. That cuts off the _Allocated piece of the name, just leaving the state.
A crosstab tool with Sum will then add up the appropriate data by state, combining the original number with the allocated number, no new columns needed.