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?

"מיכ�ל (מיקי) �בידן" wrote:

You will notice 2 things:
1) My sheet layout is from right-to-left which makes no difference as for
the solution.
2) I have changed the Ratings, on purpose, in order to be sure the formula
returns the expected values
Micky


"מיכ�ל (מיקי) �בידן" wrote:

I hope this will help:
http://img59.imageshack.us/img59/2067/nonameo.png
(*** The formula which returns the names is an array formula, and is to be
confirmed with CTRL+SHIFT+ENTER rather than with simply ENTER.
The curly brackets {} are not to be typed manually, those are entered by the
€œExcel€�, when the formula is entered as an Array formula).
Micky


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