I have 2 columns from a read only MySQL view source.
The table is supposed to have a 4 digit number and possibly a letter in the “Code” Column and a brief text translation associated with the “Code” in the “Translation” Column.
Unfortunately they are swapped between the 2 columns in some rows.
How can I do the following steps:
Fix it so all “Code” are in Code Column and Vice Versa
Use Text.PadStart to get the leading 0s back so it’s always at least 4 numbers and possibly a letter
Sort ascending “Code Column”
Attached is a sample table.43495-sample-translation.pdf