How to move data to the left most field

I have a spreadsheet that looks like this:

Invoice # Item Code #1 Item Code #2 Item Code #3 Etc Etc

1 1 5 9
2 66 47
3
4 5
5 47 66
6 5 7
7
8
9
10 5


The numbers are different, but is there an easy way to move any field with a character in it to the left as far as it will go. I want it to look like this when finished:

Invoice # Item Code #1 Item Code #2 Item Code #3 Etc Etc

1 1 5 9
2 66 47
3
4 5
5 47 66
6 5 7
7
8
9
10 5


Any help would be great,

Thanks in advance,

Chad

Your example doesn't help because as you can see they are identical. Perhaps select the range and try this,:

Please Login or Register  to view this content.

Sorry- formating got the bast of that thread. Here is an .xls file on Sheet 1 is how my data comes, Sheet 2 is how I want it to look. Is there any easy way through excel or a macro I could use. In my real data pool I will have more columns and many more rows.

Thanks in advance,

Chad

1. loop through each row (until last used row)
2. have another nested loop inside this loop to looop through each column. (This way you loop through each used cell in the excel file)
3. if a cell is blank, check upto two cells (or whatever no. of cols) to its right.
4. If you find any data in these cells, cut -paste to current cell.

hth
Ajay

Thank you- are there any pre-made macros to do this as I do not know how to program other than manual macros....

Did you try my line of code?