Hi
Try this
| makeresults
| eval id="02,03,01"
| makemv delim="," id
| appendcols
[| makeresults
| eval Number="30,20,40"
| makemv delim="," Number]
| appendcols
[| makeresults
| eval Status="In progress,In Progress,To Do"
| makemv delim="," Status]
| fields - _time
| eval temp=mvzip(mvzip(id,Number),Status)
| fields temp
| mvexpand temp
| eval temp_value=split(temp,",")
| eval id=mvindex(temp_value,0), Number=mvindex(temp_value,1), Status=mvindex(temp_value,2)
| table id Number Status
... View more