Convert vertical data to horizontal data

  • Thread starter Thread starter Kiley
  • Start date Start date
K

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?
 
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."
 
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.
 
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.
 
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?
 
Back
Top