Combine data from multiple rows based on a key

  • I've found questions that are similar to mine, but different enough that I haven't been able to modify the solutions to work in this situation. I have a large data set of student information and test scores collected at different times. I want to combine all the information for each student (based on student ID) into 1 row. Sometimes the information is duplicated (i.e. gender may be recorded several time) but students never have conflicting data in any given column. Here is an example of what I am starting with and what I'm hoping to get to:

    [ATTACH=JSON]{"alt":"Click image for larger version Name:\tCombineRows.JPG Views:\t1 Size:\t59.2 KB ID:\t1203965","data-align":"none","data-attachmentid":"1203965","data-size":"full","title":"CombineRows.JPG"}[/ATTACH]

    I have a feeling I've made this much harder than it is, but I truly cannot figure it out. Any help is appreciated. The sample file is attached.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!