Problem description & analysis:

Here below is a data table:

Task: 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:

Solution:

Use SPL XLL and enter the following code:

=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.

Download esProc Desktop for FREE and boost productivity today!!! 🚀✨⬇️

✨SPL download address: esProc Desktop FREE Download

✨Plugin Installation Method: SPL XLL Installation and Configuration

✨References to other rich Excel operation cases: Desktop and Excel Data Processing Cases

✨YouTube FREE courses: SPL Programming