Help rearrange rows and columns within scorecard

I work for a data company and need to put together a scorecard. Originally, I was spending hours copying and pasting and decided to see if I could try something different. I was able to get something...