Push the row-data to upper rows of the same column if the upper-rows are empty.

[abhishekpatel2]

Currently I am having some  blank cell or null data in some row. So how can I fill that cells or rows with the data  that is in below row of that columns:

Currently my output for the query is:

The Output that I want is:-

Can someone please help me with this..

[aasabatini]

Hi 

you can use "Sort" comand to order your output.

In addiction you can use fillnull comand to fill your blank fields 

https://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Fillnull

[abhishekpatel2]

It only fill that field with null in case of fill null and sort columns if I use sort. But  I want to push the  row data to upwards to remove the blank rows.

[aasabatini]

In your case you need to use at the end of your search:

| sort -a (field)