sorry, no problem.

basically, I was just a problem arranging all the information I had. If I tried running a pivot on the data that I had, just the way it was, I was getting an error( rookie mistake) that the data must be organized as a list with labeled columns. So I just rearranged the data I had. Book1 (2).xlsx