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


--
maxmil
------------------------------------------------------------------------
maxmil's Profile: http://www.excelforum.com/member.php...o&userid=24396
View this thread: http://www.excelforum.com/showthread...hreadid=530951

Max,

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

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=530951

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.

I have done it.


--
maxmil
------------------------------------------------------------------------
maxmil's Profile: http://www.excelforum.com/member.php...o&userid=24396
View this thread: http://www.excelforum.com/showthread...hreadid=530951