How do I add every two rows into a seperate column?

[akhera]

I want to add every two rows in a column and display them in new column as new total:

Column1
1

2
5

7
8

9

NewTotalColum

3

12

17

Any leads will be helpful.

[mstjohn_splunk]

Hi @akhera,

Did the answer below solve your problem? If so, please resolve this post by approving it! If your problem is still not solved, keep us updated so that someone else can help ya. Thanks for posting!

[akhera]

@mstjohn_splunk @renjith.nair This is really helpful and it solved my issue. thanks for your help and support.

[renjith_nair · Accepted solution]

@akhera,

Try this,

your search|streamstats current=f window=1 last(Column1) as prev|eval rowno=1|accum rowno
|eval Total=if(rowno%2==0,Column1+prev,null())|fields - rowno,prev

You shall change the logic to display data in alternative columns if needed