Using stats to organise repetitive data

[leonheart78]

I have a set of data as below:

If you can see, the TagNames are repetitive. I would want to re-arrange it to below format

TagName LimitString1 LimitString2 LimitString3 .. . . . . . . . . .

CHEM_R13719 null 18
CHEM_R13720 null 01
.
.
CHEM_R13723 0 4940

May I know how can I use stats command to achieve this? Thank you

[utk123]

It seems you are looking for something like this:
index=.... | stats list(LimitString) as "Limit String" by TagName

[DalJeanis]

Try...

 Your search
| eval LimitString=coalesce(LimitString,"")
| stats count by TagName LimitString

[leonheart78]

Unfortunately, the output is not what I required. Basically, we need to sort the values in LimitString, into the respective TagName. I was reading up on the "bin" command, not sure it would help in getting what I wanted.