Rearrange Columns in Excel
A recent query involved how to rearrange columns in Excel into a specific order. In this case it involved a weekly download from SalesForce and a requirement to (easily) move the columns around into a specific order.
For small changes you can simply insert some columns and cut and paste the columns into the appropriate order. But what if you need to move 30+ columns around every week?
Another idea is to use the Data Sort Left to Right feature.
- Take the download and in a row at the top, number the columns in the order you want them to appear.
- Highlight all the data including the row with the sort order.
- Click on DATA SORT
- Click on OPTIONS
- Click on SORT LEFT TO RIGHT
- Click OK
- Choose the correct row in the ‘Sort By’ drop down list
Easy way to move your columns around.