Hi
Follow these steps:
1. Select all the columns up to the last column containing data.
2. Click on the Data tab.
3. Click on the Sort button.
4. In the Sort dialog box click on Options.
5. Select Left to Right.
6. Click OK.
7. Select Row 1 to sort by.
8. Click OK.
This will sort by columns rather than rows and shift all empty column to the right of your data.
Good luck.
Tony