suri tamna
New Member
- Joined
- Oct 8, 2019
- Messages
- 1
I searched for a similar situation to mine and didn't see one (apologies if one exists and I missed it!)
I have to format a long list of managers and their employees for mass emails, and the lists I get from our database are:
<tbody>
</tbody>
But I need the data to be formatted like this:
<tbody>
</tbody>
So, I'd like to sort all employees who report to the same manager so that they appear on the row next to that manager rather than in a column with the manager's name listed as many times as there are employees reporting to that manager. I sometimes have situations where there are 20 people reporting to a manager, and I have thousands of records to transpose, so doing this manually is a real bummer.
Thank you in advance to any solutions, and let me know if I can clarify anything.
I have to format a long list of managers and their employees for mass emails, and the lists I get from our database are:
Manager 1 | Employee A |
Manager 2 | Employee B |
Manager 2 | Employee C |
Manager 2 | Employee D |
Manager 3 | Employee E |
Manager 3 | Employee F |
Manager 4 | Employee G |
Manager 4 | Employee H |
<tbody>
</tbody>
But I need the data to be formatted like this:
Manager 1 | Employee A | ||
Manager 2 | Employee B | Employee C | Employee D |
Manager 3 | Employee E | Employee F | |
Manager 4 | Employee G | Employee H |
<tbody>
</tbody>
So, I'd like to sort all employees who report to the same manager so that they appear on the row next to that manager rather than in a column with the manager's name listed as many times as there are employees reporting to that manager. I sometimes have situations where there are 20 people reporting to a manager, and I have thousands of records to transpose, so doing this manually is a real bummer.
Thank you in advance to any solutions, and let me know if I can clarify anything.