How do I align cells in Excel onto one line?

[Guest]

Hi
I want to align cells in Excel onto one line.
Example data:

Column1 Column2 Column3 Column4
Row1 ABC
Row2 DEF
Row3 GHI
Row4 JKL

Should be

Column1 Column2 Column3 Column4
Row1 ABC DEF GHI JKL

Thanks a mil

 

[Arvi Laanemets]

Hi

Into B1 enter the formula
=(OFFSET(B1,COLUMN()-1,)
Copy the formula in B1 to right for as much columns as you have them in
table
Select all cells with formulas in row1, copy them, and replace with values
(PasteSpecial.Values)
Select the range from B2 to lower right corner of table, and clear all
entries (when you have in some cells formulas or values which must remain,
then probably you have to clear diagonal cellwise instead).

 

[Debra Dalgleish]

Select all the cells
Choose Edit>Go to, and click the Special button
Select Blanks, click OK
Choose Edit>Delete
Select 'Shift Cells up', click OK