Selecting vertical rows and displaying them horizontally.

[chrisvail]

This may be any easy thing to do but I'm trying to do the following and I
need a very detailed explanation of how to do it so any help is truly
appreciated. The employees will be grouped but their subordinate will need to
be displayed on the same row as the employee with each subordinate in a
different column for each employee.

I trying to convert this type of table:
EMPLOYEE SUBORDINATE
Employee 1 Subordinate A
Employee 1 Subordinate B
Employee 2 Subordinate C
Employee 2 Subordinate D
Employee 3 Subordinate E
Employee 3 Subordinate F

To this type:
EMPLOYEE SUBORDINATE 1 SUBORDINATE 2
Employee 1 Subordinate A Subordinate B
Employee 2 Subordinate C Subordinate D
Employee 3 Subordinate E Subordinate F


Thank you,

Chris

 

[FSt1]

hi
yes. might be a tad manual but
sort you data as you have in the first group.
then on a seperate part of the sheet or another sheet, copy all of your
employees so that there is only one.
then on the first sheet, copy the subordinates associated with the employee
and on the second sheet, paste special transpose. this will turn the columns
in to row. do that for each employee.

in excel vertical rows are usually refered to as columns.

Regards
FSt1

 

[chrisvail]

Thank you for your post but I have a couple of thousand employees that I need
to do this for so a manual process would take too long.