Convert vertical data to horizontal data

[Kiley]

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?

 

[Kiley]

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."

 

[Luke M]

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.

 

[Kiley]

There are other entries in between the names and ratings.

The names appear in column a, then there are four columns of other
information, and then the ratings. However, I can take out the other
information if it will make it easier.

Please let me know if you need more information. Thank you for your help on
this.

 

[Kiley]

I decided I better not wait. Please email to (e-mail address removed). Thank
you.

 

[Kiley]

Thank you so much for the formulas. It is working great. However, I have
another question. If I have 8 ratings per employee, how does it affect this
formula: =OFFSET(B$1,ROW()*6-11,). What would need to change in the formula?