How can I reverse the x and y axes?

[kennethyeung]

current I have this search:

......||addcoltotals | table *_August_R | reverse | head 1 

1_Ausgust_R,2_Ausgust_R,3_Ausgust_R,4_Ausgust_R,
26                    30                   15                       27

I want to change it to

Date, Number
1_August, 26
2_August, 30
3_August, 15
3_August, 27

[HiroshiSatoh · Accepted solution]

Try this!

    ......|addcoltotals | table *_August_R | reverse | head 1
|transpose|rename column as Date,"row 1" as Number|eval Date=substr(Date,1,len(Date)-2)

[kennethyeung]

1 more question now, if
......||addcoltotals | table *_August_R , *_August_A| reverse | head 1
1_Ausgust_R,2_Ausgust_R,3_Ausgust_R,4_Ausgust_R, 1_August_R , 2_August_R
26 30 15 27 5 20

want to do below
Date , Number, Another Number
1_August, 26, 5
2_August, 30, 20
.....

how do i use eval but base on other col