Forum Discussion
HELP! Consolidating data in spreadsheet without data loss
I have a dataset that I'm trying to consolidate into unique records without losing any data. Each observation has an SSID number, and there are duplicate entries in the SSID number column. I don't ...
What would be your desired output? Can you attach a sample file.
Sample output would look like this:
It preserves the 'yes' in column D for student #1234, and also preserves the grade in column H for student #1234's original duplicate record.
The 'General or Topical Math' is a placeholder and could be removed and re-added later, but I'd like to keep the subject-specific math courses like AP calculus and Pre-Algebra in the sample file.