Hi Jake

You could insert a new column A.
In A1 enter
=LOOKUP(99^99,B1:J1)
and copy down as far as required
Then copy column Apaste SpecialValues back over itself to "fix" the values
You can then delete columns B:J
--
Regards
Roger Govier

"JakeShipley2008" wrote in
message ...
I am trying to shift about 9 columns of data that contains some data but
mostly empty rows. I would like to shift all the data in each column left.
leaving the data in the same row resulting with all data in column a. Any
help would be greatly appreciated.
--
Jake