Turn Sample Counts into Individual Observations - Uncount
Sometimes you may have some data that have been aggregated by counting the number of observations. This is where the uncount function is useful. This function is found under Advanced in the left-hand menu:
To do this:
1) Set your counted variable to Sample Count type.
2) Go to the hamburger menu, select Advanced, and then Uncount. You will now see this. Select the variable you wish to "uncount" into single observations.
3) You should now see a new variable with all your "sample count" values separated out into individual observations.
NOTE
First you need to ensure that the column with the number of observations has been set to the correct type: Sample count as in our example dataset.