Hi everyone,

I have a question about cleaning my dataset, so I get for each cz (czone) the totals in one row.
As you can see below there are 3 observations for each czone and I'm wondering if I can merge this somehow into one row (without saving each variable separately and then merging all the created datasets).
So what I want is:
cz - total8891 - total 9199 - total 9907 - total 0711
100 - 913,6012 - 1190,8258 - 1091,1765 - 643,9245
200 - 0 - 77,22823 - 239,7924 -231,93645

It is necessary to combine them into one, because right now I cannot map this data because cz is not an unique variable.

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input float(cz total8891 total9199 total9907 total0711)
 100  913.6012         .         .         .
 100         . 1190.8258 1091.1765         .
 100         .         .         .  643.9245
 200         0         .         .         .
 200         .  77.22823  239.7924         .
 200         .         .         . 231.93645
 301         0         .         .         .
 301         .         0         0         .
 301         .         .         .         0
 302  456.8283         .         .         .
 302         .  619.5192  788.2296         .
 302         .         .         .  648.9695
 401         0         .         .         .
 401         .  3.068389 148.38516         .
 401         .         .         . 273.75842
end
I'm sorry if there was already a topic about this, but I have no clue where to look for.
Thank you in advance!