Okay, I am still not getting it. So let me rephrase my issue. I have a
large spreadsheet of student test data. Each student record is identical
except to for the test data. Each student could have up to 4 records.

Bill Smith, History, 555
Bill Smith, Math, 222
Bill Smith, ELA, 330
Mary Johnson, History 333
Mary Johnson, Math 331

Each student has a unique student ID. How can I take this spreadsheet and
change it to reflect

Bill Smith, History, 555, Math, 222, ELA, 330
Mary Johnson, History, 333, Math 331


The order doesn't matter. There can but up to 4 tests. I just want to see
one horizontal line for each student with the scores listed horizontally.

Can you help me with this?

Thank you very much.