Excel 2007.
I need to find a way to move data in a row to the next available cell in that row. Not sure if that makes sense so here is an example.

A B C D E F G
C1003 LF NX NP
C1004 NP
C1005 NS NX
C1006 NS NP
C1007 NS LF NX NP



Below is what I want the end result to look like
A B C D E F G
C1003 LF NX NP
C1004 NP
C1005 NS NX
C1006 NS NP
C1007 NS LF NX NP


Any help on if this is even possible would be great....

Thanks,
KC

Well, since your before and after samples look to be identical the easiest thing to do would be nothing.

Fantastic that is what I wanted it to do in excel was to take out my spaces. Anyway does hopefully this makes more sense. Sorry

A__________B_________C________D_________E__________
C1003 ______________LF________NX________NP
C1004 __________________________________NP
C1005 ____NS _________________NX
C1006 ____NS ___________________________NP
C1007 ____NS________LF _______NX________NP



Below is what I want the end result to look like
A_____B__C__D__E__F__G
C1003_LF NX NP
C1004_NP
C1005_NS NX
C1006_NS NP
C1007_NS LF NX NP

If this is a one-time operation I'd be inclined to:

Concatenate everything in each row together with a delimiter between cells and trim the result. =Trim(Concatenate(A1,",",A2,",",A3,",",A4.......))
Paste-special, values the results into a clean place.
Apply Data | Text to columns with "treat multiple delimiters as one" to that.

It is a one time operation. I was hoping to avoid doing that mostly because I have 88 columns that I would have to Concatenate. Unless there is an easier way to Concatenate 88 columns with a delimiter between each cell.

Save as csv.

The .CSV got me thinking
I saved as a .txt file then opened in Excel I had a comma for every column there is a check box in excel that says Treat consecutive delimiters as one so that worked