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
