Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Rearrange Order Of Columns In Table. Of course I can right click within an existing table and change the order ie select Properties Columns and then change the display order of columns for that table. It isnt as elegant as a simple move column command but it should do what you want.
Click the heading of the column you want to move. Rearrange the order of columns in a table. Data view shows the last changed column last.
Retain that descending order there by reordering in descending order.
Then go back to power Query view delete the removed Columns Steps in the desired order and then your columns in Data view will be reordered. Alan - you can try the following to move the 20th column to the second position CUTable CUTable1 CUTable20 CUTable219. You can reorder fields on the Fields tab of the Layer Properties dialog box or manually in the table. To manually reorder the fields in a table follow these steps.