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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top