Hello! I have data that looks like this:
<tbody>
</tbody>
And I want it to look like this:
<tbody>
</tbody>
So there are no duplicate rows anymore. I need to keep the first 4 columns.
Name | ID | Position | School | Endorsement |
Joe | 123 | Teacher | Stellar Elementary | Endorsement 28 |
Joe | 123 | Teacher | Stellar Elementary | Endorsement 35 |
Joe | 123 | Teacher | Stellar Elementary | Endorsement 12 |
Jim | 124 | Custodian | Thunder Middle | Endorsement 25 |
Jim | 124 | Custodian | Thunder Middle | Endorsement 1 |
James | 125 | Teacher Elem | Lightning Elementary | Endorsement 15 |
Jill | 126 | Teacher | North High School | Endorsement 28 |
<tbody>
</tbody>
And I want it to look like this:
Name | ID | Position | Endorsement 1 | Endorsement 2 | Endorsement 3 |
Joe | 123 | Teacher | Endorsement 28 | Endorsement 35 | Endorsement 12 |
Jim | 124 | Custodian | Endorsement 25 | Endorsement 1 | |
James | 125 | Teacher Elem | Endorsement 15 | ||
Jill | 126 | Teacher | Endorsement 28 |
<tbody>
</tbody>
So there are no duplicate rows anymore. I need to keep the first 4 columns.