I need help in transposing the attached data --
Current data to Desired data tab.
Not sure if crosstab or transpose is the best tool to use for this. Thoughts and insights are welcome.
@lmaughan
The answer would be both! First transpose to get gross and reserve as rows, then crosstab by state:
Edited to fix column
Hi @lmaughan,
I need to work on my cross tab transpose skills. As it looks that it could be easily done... Looking at your solution @Luke_C
