How to Perform Inverse Transposition

The following is part of the Excel file source.xlsx:

Suppose the number of columns in the two-dimensional table is M. The task is to transpose the table into a new one having M rows in an inverse direction beginning from the Mth column. That is, M-1,M-2…2,1.

The expected result:

It’s convenient to perform an inverse transposition with esProc. Download esProc installation package and free license file HERE.

1. Write script rvstrans.dfx in esProc:

2. Select the source data area A1:D5 in the Excel file, press Ctrl+C to paste it onto the clipboard. Open esProc IDE, enter and execute the above script. A5 is the final result. Then we copy A5’s value, open Excel, select cell A7 and press Ctrl+V to paste the result in.

Copy the final result in A5:

Paste the result back to Excel:

If there are specific requirements about the final result, such as every two of the rows need to be separated by two empty rows, you can directly modify the final result string using =replace(A5,”\n”,”\n\n\n”). The expression means replacing the one line break by three line breaks.



Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store