My data is stacked in the attached table. The column "Instance" has values 1 through 80.
When I try to split column "Data" by "Bubble" it seems like I am losing some values in the instance column, since the largetst value in the new Instance column is 31. I made a video going through the actions to illustrate the point.
The overall number of rows is correct, but it looks like unique values of Instance are being lost. Am I missing something simple? Any help is appreciated.
