Here below is a data table:

Now we want to transpose the M columns of a two-dimensional table to M rows, and the transposition order should be: the M-th column, M-1 column, M-2…2, 1. The results are as follows:

Script:

=spl("=transpose(?1).rvs()",Sheet1!A1:D5)

Reverses the order of the columns after transposing.

Script for reverse transposing:

=spl("=transpose(?1).(~.rvs())",Sheet2!A1:E4)

It should be noted what is reversed here is the order of rows.

esProc Desktop and Excel Processing
13.12 Interconversion of rows and columns within a group
14.1 Generate continuous array