How to group each full iteration into single fields?

[ABSplunker93]

I have a stats table with output in the below format:

Device                          Timestamp        Action

some value                some value.             1

some value              some value.              2

..                     ..                                .. 

some value                some value              10

some value                 some value               1

some value              some value.                  2

..                     ..                                .. 

some value                some value              10

So, the action column repeats the pattern after a certain number of iterations. How to group these into single fields, that is, each full iteration should be stored as a mv field.

[richgalloway]

The stats command doesn't create arbitrary patterns the results.  Either the pattern exists in the data or it's introduced in the query.  You may need to add or change the by clause in the stats command.  For more specifics, please share the SPL and a sanitized data sample.