Changing the layout of a series of fields from Column to row

M

maxmil

Hi everybody,

Do you know how to change the layout of a series of fields from column
to row? I have copied a printscreen of some descriptions in a column of
excel.
Now I need to have them arranged in a row.

Could you please help me?

Thanks
Max
 
S

SteveG

Max,

Copy your column of data. Chose the cell to paste in row format.
Edit>Paste Special select the Transpose Option and click OK.

HTH

Stev
 
D

Dave O

I wasn't able to view your screenprint, but here's a suggestion.

If the data is all text, highlight the range and copy it into the
clipboard. Then select a new location and click >Edit >Paste Special,
click the Transpose box, and click OK.

If the data contains formulas, the formula references will be altered
when you transpose them. To avoid this, highlight the range and
perform a search and replace: look for the = sign and replace it with a
text string such as your initials. This converts the dynamic formulas
to static text strings, and the references will not change. Then
perform the transpose operation above, and when it's finished reverse
the search and replace: look for your initials, and replace with the =
sign.
 
Top