1. Are any of the cells merged cells? This can cause problems
2. Only select a single cell before the paste operation.

Alternatively, you can use the formula (assumes data starts in B2):

=OFFSET($B$2,COLUMN(A1),)

Copying this across will give a similar effect.

--
Best Regards,

Luke M
"Kiley" wrote in message
...
I think I need more information. I tried what you suggested but I got the
following message: "The information cannot be pasted because the Copy
area
and the paste area are not the same size and shape."

"Russell Dawson" wrote:

Copy - paste special - transpose
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Kiley" wrote:

I have a listing of 6 performance ratings for each employee. The
ratings
appear vertically. How do I convert the ratings data to a single row
for
each employee?