If you use http://www.gmayor.com/ManyToOne.htm (read the web page). Then what you ask is straightforward.

Sort the worksheet on the manager name field. Put the manager's name field at the top of the page and under it put a one row table (with or without a border. Put the fields relating to the people in the table cells, and merge many to one with the fields in the table as child fields and the manager field as the key field.

Once familiar with the principles you can format the document as required before running the merge.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com