A friend of mine asked a group of us on Voxer how to rearrange some data. Several of us racked our brains for a couple of days. Just on a whim, I decided to check out Pivot Tables. I’ve never used them before and honestly don’t know what made me try. But it worked!!!!
Here is a quick video of how I explained it to others in our group.
I hope it helps you as much as it did us. Happy Pivoting!