How do I align cells in Excel onto one line?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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).
 
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
 
Back
Top