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.

--

--

--

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Containers deployment to Kubernetes via Jenkins. A tiny fairy tale.

Winrar Free Download Windows 10

How to get your first software testing job

How to get your first software testing job

Hello David…I am Johnny, you are my Ai.

Java’s LinkedList Data Structure by Example

Dino Cajic explaining Java’s Linked List Data Structure

Student Code-In and Open Source

Deployment Testimonials: Issues, Challenges and Architectural Orthodoxy

The tech world is more than just coding.

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
chuxin huo

chuxin huo

hello:)

More from Medium

Xiaomi’s CyberDog — An alternative to Boston Dynamics $70,000 robot dog

CS373 Spring 2022: Vijay Kiran Vuyyuru

Aflorithmic Welcomes VocaliD to Api.audio