| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert vertical data to horizontal data
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert vertical data to horizontal data
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert vertical data to horizontal data
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert vertical data to horizontal data
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert vertical data to horizontal data
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. "Russell Dawson" wrote: Kiley, Please clarify. If the names are in column A - is it only the names that appear in col A or do you have other entries between the names? You may have left descriptions out for simplicity but I was thinking that if only the names appear in A then that can be used to differentiate between employees. Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Kiley" wrote: I figured it out how to covert for one employee, but if I have a list of employees, how can this be done for each employee? Name Ratings Joe Excellent Effective Excellent Needs Development Effective Needs Development Jim Excellent Effective Excellent Needs Development Effective Needs Development "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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert vertical data to horizontal data
Kiley,
Please clarify. If the names are in column A - is it only the names that appear in col A or do you have other entries between the names? You may have left descriptions out for simplicity but I was thinking that if only the names appear in A then that can be used to differentiate between employees. Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Kiley" wrote: I figured it out how to covert for one employee, but if I have a list of employees, how can this be done for each employee? Name Ratings Joe Excellent Effective Excellent Needs Development Effective Needs Development Jim Excellent Effective Excellent Needs Development Effective Needs Development "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? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert vertical data to horizontal data
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? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert vertical data to horizontal data
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turn vertical data to horizontal data automaticaly | Excel Worksheet Functions | |||
| Reformattign Data/Converting-Combinign Vertical Data to Horizontal | Excel Worksheet Functions | |||
| how do i convert vertical data into horizontal data | Excel Discussion (Misc queries) | |||
| Need lookup of data both vertical and horizontal | Excel Discussion (Misc queries) | |||
| transposing vertical data to horizontal with varying amount of data | Excel Discussion (Misc queries) | |||
Linear Mode
