Skip to main content
Participating Frequently
September 1, 2024
Answered

Tables: transposing columns

  • September 1, 2024
  • 2 replies
  • 650 views

I have a table 5 columns by 170 rows. I want to transpose the 4th and 5th columns and I can't find any advice on this.  Thank you.

This topic has been closed for replies.
Correct answer FRIdNGE

Hmm! …

 

Just select the column and move it!

 

(^/)  The Jedi

2 replies

jmlevy
Community Expert
Community Expert
September 2, 2024

As @FRIdNGE wrote:

Just select the column and move it!

 

James Gifford—NitroPress
Legend
September 1, 2024

No simple method, but I'd bet there's a script out there. In lieu of one:

  • Select column to move (down-arrow at top indicates selection mode).
  • Cut.
  • Insert (new, empty) column where desired using menu, right-click menu or alt-drag.
  • Select new column.
  • Paste.
Robert at ID-Tasker
Legend
September 1, 2024

Script for something so simple would be an overkill - unless there are 100s of tables to process. 

 

James Gifford—NitroPress
Legend
September 2, 2024

Wow, I'm going to frame that. 😄