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

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

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

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

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

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.

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

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