#139 — Interconversion of Rows and Columns in Reverse Order

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 a…


This content originally appeared on DEV Community and was authored by Judith-Excel-Sharing

Problem description & analysis:

Here below is a data table:

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

expected results

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


This content originally appeared on DEV Community and was authored by Judith-Excel-Sharing


Print Share Comment Cite Upload Translate Updates
APA

Judith-Excel-Sharing | Sciencx (2025-02-05T06:15:37+00:00) #139 — Interconversion of Rows and Columns in Reverse Order. Retrieved from https://www.scien.cx/2025/02/05/139-interconversion-of-rows-and-columns-in-reverse-order/

MLA
" » #139 — Interconversion of Rows and Columns in Reverse Order." Judith-Excel-Sharing | Sciencx - Wednesday February 5, 2025, https://www.scien.cx/2025/02/05/139-interconversion-of-rows-and-columns-in-reverse-order/
HARVARD
Judith-Excel-Sharing | Sciencx Wednesday February 5, 2025 » #139 — Interconversion of Rows and Columns in Reverse Order., viewed ,<https://www.scien.cx/2025/02/05/139-interconversion-of-rows-and-columns-in-reverse-order/>
VANCOUVER
Judith-Excel-Sharing | Sciencx - » #139 — Interconversion of Rows and Columns in Reverse Order. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2025/02/05/139-interconversion-of-rows-and-columns-in-reverse-order/
CHICAGO
" » #139 — Interconversion of Rows and Columns in Reverse Order." Judith-Excel-Sharing | Sciencx - Accessed . https://www.scien.cx/2025/02/05/139-interconversion-of-rows-and-columns-in-reverse-order/
IEEE
" » #139 — Interconversion of Rows and Columns in Reverse Order." Judith-Excel-Sharing | Sciencx [Online]. Available: https://www.scien.cx/2025/02/05/139-interconversion-of-rows-and-columns-in-reverse-order/. [Accessed: ]
rf:citation
» #139 — Interconversion of Rows and Columns in Reverse Order | Judith-Excel-Sharing | Sciencx | https://www.scien.cx/2025/02/05/139-interconversion-of-rows-and-columns-in-reverse-order/ |

Please log in to upload a file.



There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.

Related Posts