You can use streamstats in combination with mvexpand to achieve that.
The section up to here is used to produce your kind of data (and to add an unique identifier):
* | head 2 | streamstats count AS ID | eval value=if(ID=1,"A,B,C,D,E,F","G,H,I,J") | makemv delim="," value | table ID value
Now to return the position you use the following code:
* | head 2 | streamstats count AS ID | eval value=if(ID=1,"A,B,C,D,E,F","G,H,I,J") | makemv delim="," value | table ID value | mvexpand value | streamstats count AS position by ID | table value position
... View more