How do I display this data in a differnet format?

G

Guest

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
 
N

Niek Otten

Copy, Paste special, check Transpose

--
Kind regards,

Niek Otten

|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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average if questions 2
Select and input data from a list 1
Matching data and returning header 2
move two columns of data to four columns 1
Move two columns to four columns 2
Adjusting chart info 1
Outline a worksheet 1
Calculate accumulative total, based on conditions of two different 2

Top