Hi altruist,

I am just wondering whether STATA has any function to convert aggregated count data into individual row.
For example, I have audited different parks and counted how many people are doing three different types of physical activity.
I did that multiple times in same park.
So in my raw data each row is a park and each column include 'female walking' and 'male walking' etc.
Now I want a new data where row number will be equivalent to the count of each of the activities.
I have attached a screenshot of my raw data (first) and also how the restructure may look like (2nd).
Can anyone tell me whether it is possible to restructure in STATA or not?

Thank you very much in anticipation.

best regards,

FaysalArray Array