Lorraine,
First, you need to add to your tool bar the "select visible cells" button.
It can be found in the "Edit" category. Next, hide the columns that don't
have any data in the row you are trying to copy. Highlight that row, click
on the "select visible cells" button, then click on the copy button. Put
your cursor where you want to paste, select paste special, transpose and it
should work.

Good Luck!,
Lisa

"lorraine knight" wrote:


I am trying to copy a row, using paste special "transpose" to paste in a
column, but I dont want to copy any blank fields, How can I do this

Lorraine


--
lorraine knight
------------------------------------------------------------------------
lorraine knight's Profile: http://www.excelforum.com/member.php...o&userid=35294
View this thread: http://www.excelforum.com/showthread...hreadid=551034