How do I align cells in Excel onto one line?

M

Mario

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
 
A

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).
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top