Excel challenge question

I have a very large database that needs to be split up in an interesting way and I can’t figure out how to word the question for google. Here is my best shot as a description. I have rows with abou...