0

I'm sorry if the title is confusing but I had a hard time deciding how to word it.

I have students with test scores and the scores are currently laid out so column headers are as such:

Student ID, Math Score, Writing Score, Reading Score

I would like it so the columns would instead be:

Student ID, Subject, Score

Essentially I am categorizing my data and will end up with multiple rows with the same student ID as it touches each subject and score.

My data is for hundreds of students and many different types of scores hence the need to find a way to do this without dragging fields around to reorganize the data.

I've already run into this type of need twice in the past few months so I can't imagine others haven't encountered this..

I am not sure if functions will do this or a tool already within Excel. Or maybe its not possible?

Scott Craner
  • 148,073
  • 10
  • 49
  • 81
david-00001
  • 1
  • 1
  • It is called un-pivot or Flatten the data. Using Power pivot is probably the best tool for this. See the Teylyn's answer here: https://stackoverflow.com/questions/20541905/convert-matrix-to-3-column-table-reverse-pivot-unpivot-flatten-normal – Scott Craner Feb 09 '23 at 20:45

0 Answers0