Reply To: Swap words order

#82020

Is it possible to copy that single column out of the table, and then manipulate it separately, then re-insert it?
If the column is consistent, you might be able to:
convert the table column to text with suitable delimiters between the two entries in each row,
re-convert that text to a two-column table (using those delimiters, so that the first element of each row is now in column 1 and the second element is in column 2),
swap the order of the two columns…

then reverse the process:
re-convert to text,
re-convert to a single column table,
re-insert into the original table.

Does that make sense? It’s almost harder to explain it than to do it.

Good luck,
Chris.

This article was last modified on February 15, 2016

Comments (0)

Loading comments...