| 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? |
| 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) | |||
Hybrid Mode
