removing empty cells in a rows of data

A

Allan_Jackson

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) I have may rows of data and I want to remove the empty cells. eg
     A B C D E F G H
1 X X X X
2 Y Y Y Y
3 Z Z Z Z

I want it to look like this without having to copy/cut and paste.
    A B C D
1 X X X X
2 Y Y Y Y
3 Z Z Z Z

Is there any automated way to achieve this? Thanks Allan
 
Top