I will try my best to describe my problem and I may be overcomplicating it. I have a data set with columns that contain scores pertaining to each Customer ID in a row. So you have Customer ID with CP SCORE in one column, TECH SCORE in another etc.
I want to be able to create a table that formats the column heading as a ROW with the groups associated within that, stacked on top of one another:
CP SCORE GROUP 2
TECH SCORE GROUP 2
As opposed to it trying to format like this:
CP SCORE TECH SCORE GROUP 1
Does this make sense?
It sounds like CP SCORE and TECH SCORE are two different fields. If this is the case, I would recommend either reshaping the data so that they are in the same field or creating two worksheets (one with CP SCORE and one with TECH SCORE) and placing them on a dashboard together. Hope this helps a bit!