Hello everyone,

I have a dataset in the format "variable : value" (see also the following example).
v1 v2 v3 v4 ...
1 observation1 variable1:value11 variable3:value13 variable4:value14 ...
2 observation2 variable2:value22 variable6:value26 . ...
3 observation3 variable1:value31 variable2:value32 variable5:value35 ...
... ... ... ... ...
whenever a variable is missing for one observation, the variable is not shown in the row belonging to the observation.


Now I prefer a dataset with the follwing structure:

identifier variable1 variable2 variable3 variable4 variable5 variable6
1 observation1 value11 . value13 value 14 . .
2 observation2 . value22 . . . value26
3 observation3 value31 value32 . . value35 .
How can I reshape the dataset using Stata?

I would appreciate your help!
Yusuv