DanniiMarie
New Member
- Joined
- May 21, 2018
- Messages
- 30
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Platform
- Windows
- MacOS
- Mobile
- Web
I have a list of employees and their manager's names. I need to consolidate the list so each manager name appears only once in column A and each employee is in a column to the right of the manager name. Ideally, the employees' names would be alphabetized from left to right, as well.
Here is a sample raw data set:
<tbody>
</tbody>
Here is what I'd like the final data set to look like:
<tbody>
</tbody>
I get a different data set like this each week and I'd like a less manual method to accomplish this task than what I've been using. Thanks!
Here is a sample raw data set:
Manager Name | Employee Name |
Cort Haslock | April MacGeffen |
Augusto Lampett | Averill Colbran |
Leta Bilson | Betteanne Christescu |
Benni Lait | Bonnee Plaunch |
Leta Bilson | Catarina Francescozzi |
Cort Haslock | Clive Corain |
Leta Bilson | Dory Fayne |
Joana Imeson | Josy Jereatt |
Cort Haslock | Marcelo Dumsday |
Joana Imeson | Nance Broadbury |
Leta Bilson | Quint Minette |
Benni Lait | Rosabel Bourdis |
Leta Bilson | Stefania Shute |
Moll Branscombe | Tine Cardello |
Cort Haslock | Trueman Poolton |
Joana Imeson | Vanny Jell |
Moll Branscombe | Zarla Melmore |
<tbody>
</tbody>
Here is what I'd like the final data set to look like:
Manager Name | Employee1 | Employee2 | Employee3 | Employee4 | Employee5 | |||||||
Benni Lait |
<tbody> </tbody> |
<tbody> </tbody> | ||||||||||
<tbody> </tbody> |
<tbody> </tbody> | Catarina Francescozzi | Dory Fayne | Quint Minette | Stefania Shute | |||||||
<tbody> </tbody> | Josy Jereatt |
<tbody> </tbody> | Vanny Jell | |||||||||
Augusto Lampett | Averill Colbran | |||||||||||
Cort Haslock | April MacGeffen | Clive Corain | Marcelo Dumsday | Trueman Poolton | ||||||||
Moll Branscombe | Tine Cardello | Zarla Melmore |
<tbody>
</tbody>
I get a different data set like this each week and I'd like a less manual method to accomplish this task than what I've been using. Thanks!