Excel Move Data to Next Avaliable Cell 1

[kcoleman26]

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

 

[mintjulep]

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

 

[kcoleman26]

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

 

[mintjulep]

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.

 

[kcoleman26]

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.

 

[mintjulep]

Save as csv.

 

[kcoleman26]

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