Sometimes we need to spend more time for arranging the columns in data base, where there will lot of columns and from this we need only 5 for six columns and this need to be arrange in order, For this purpose we can use a simple tip in excel by Data sort option.

Step -1

Arrange the order of the column require by updating the number in order.

Step-2

Click on the Data Tab and select Data Sort option and click on option button and select the sort from left to right and select the row number where we update the number and sort in the order of the smallest to largest and click OK.

Now the data is arranged based on the number we updated on the above row and blank will come on the same

Step-3

Just delete the columns in single option and data is arranged as per the prescribed manner.