Hi everybody
I have some data this way:
SP_E_CONSECUTIVO |
SP_Y_ESP_ENSEÑAR |
SP_Y_ESP_EVALUAR |
SP_Y_ESP_FORMAR |
EK201630003018 |
168 |
|
|
EK201630003018 |
|
150 |
|
EK201630003018 |
|
|
202 |
EK201630003986 |
183 |
|
|
EK201630003986 |
|
192 |
|
EK201630003986 |
|
|
182 |
EK201630004999 |
173 |
|
|
EK201630004999 |
|
177 |
|
EK201630004999 |
|
|
190 |
EK201630003798 |
141 |
|
|
EK201630003798 |
|
150 |
|
EK201630003798 |
|
|
135 |
EK201630003823 |
212 |
|
|
EK201630003823 |
|
181 |
|
EK201630003823 |
|
|
188 |
EK201630003906 |
213 |
|
|
EK201630003906 |
|
194 |
|
EK201630003906 |
|
|
200 |
But I want to collapse the repeated observations in one row only, like this:
SP_E_CONSECUTIVO |
SP_Y_ESP_ENSEÑAR |
SP_Y_ESP_EVALUAR |
SP_Y_ESP_FORMAR |
EK201630003018 |
168 |
150 |
202 |
EK201630003986 |
183 |
192 |
182 |
EK201630004999 |
173 |
177 |
190 |
EK201630003798 |
141 |
150 |
135 |
EK201630003823 |
212 |
181 |
188 |
EK201630003906 |
213 |
194 |
200 |
I couldn't find a quick method for doing this. Can somebody give me some advice? I'll appreciate it a lot.
0 Response to Collapsing observations in different rows
Post a Comment