Copy the row and then right click at the starting cell in the column you want
to place the row in and select PASTE SPECIAL from the shortcut menu.

Locate the TRANSPOSE check box and click to turn on, click OK to exit to the
workbook
--
Kevin Backmann


"deb" wrote:


how can i copy a row and paste it as a column?

Thanks

--
deb