Nice one Micky.
Mind you, I had done all the hard work i.e. "Copy - paste special -
transpose" !!
Cheers
--
Russell Dawson
Excel Student
Please hit "Yes" if this post was helpful.
"מיכאל (מיקי) אבידן" 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?