| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display this data in a differnet format?
I Currently have 3 columns of data. Column A is the department, B Employee &
C number of that emplyoee in that department (in sequence from 1 upwards, depending no how many people there are in the department). I am wanting to display the data the other way round, with all the departments going along ROW 1, and the employees for that department underneath. I do not need to display the employee number. If anyone can help please reply. Cheers |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I display this data in a differnet format?
Copy, Paste special, check Transpose
-- Kind regards, Niek Otten "TheRook" wrote in message ... |I Currently have 3 columns of data. Column A is the department, B Employee & | C number of that emplyoee in that department (in sequence from 1 upwards, | depending no how many people there are in the department). | | I am wanting to display the data the other way round, with all the | departments going along ROW 1, and the employees for that department | underneath. I do not need to display the employee number. | | If anyone can help please reply. | Cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| the format data - not formatted | New Users to Excel | |||
| Imported Data Date Format Problem | Excel Discussion (Misc queries) | |||
| I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
| Convert data into standard military time format | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
