I am attempting to create new groups of data from groups that have the information already combined into them. This is tricky to explain, so I will give an example first.

I think it is best to think about it as having "layers" of data:
The first layer is People. (In my example below, there are 3 people.)
Each person in "People" has multiple "Projects" (In my example below, there are 2 projects.)
Each Project has several different "Scores". (In my example below, there are 3 scores)

Right now the data is laid out in a way that will not work for my type of analysis, so I want to rearrange it. It is laid out like this (a 7x4 table):

People Project1Score1 Project1Score2 Project1Score3 Project2Score1 Project2Score2 Project2Score3
Person1 3 2 3 1 4 5
Person2 2 2 1 5 3 2
Person3 5 3 4 2 1 4

But I want to organize it so that it is laid out like this:

People Project Score1 Score2 Score3
Person1 1 3 2 3
Person1 2 1 4 5
Person2 1 2 2 1
Person2 2 5 3 2
Person3 1 5 3 4
Person3 2 2 1 4

Other sites I've asked for advice return answers with examples in macros or simple end solutions without explaining how to get there. I have knowledge in Excel, but not enough to work with VBA, macros, or complex pivot tables, so any solution with this will require a detailed step-by-step explanation of how to do it. Either way, I would appreciate a step-by-step explanation. Thanks in advance!