Hi,

You tell us there is a unique Student ID, but then you show us your data
without any Student ID? We need the student ID to solve this problem because
there could be many Bill Smith's.


--
Thanks,
Shane Devenshire


"Sprowler" wrote:

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.