How to merge columns within a table?

I have a table which I describe here (I use Microsoft 365):

1st column: Name of assistants (Names of assistants repeat up to 4 times, since they support several managers)
2nd - 4th columns: Managers (hierarchy level 1 - 4. In each column one hierarchy level)
5th - End of Table: Office addresses, phone numbers, email addresses of the assistants

The Situation:
Every single assistant supports between 1 and 4 managers.

I want to change the table as follows:
1st column: Name of all Managers independently of their hierarchy level
2nd column: Names of assistants (Names of assistants repeat, since they support several managers)
Remaining columns as before

I know how to move columns and rows.
But how can I merge the table that I have in the first column all managers and in the second column all the assistants?

I would be grateful for any idea!

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

Originally Posted by amelialogan778

To merge the columns in your table, follow these steps in Microsoft Excel

This reply looks like it has been generated by a BOT, not by you. If that's the case, it would be good to acknowledge the source...

Moreover, it does not really answer the question asked. I have just sent a message to amelialogan778 in this regard.

We do not delete accounts. We can make it inactive. However, this acts as a public database where others query Mr. Google and other search engines looking for solutions. Your issue may be helpful to others. If you have received help here, wouldn't it be nice to pay it forward? As an aside, why would you want your account deleted?