How to put the same information together in excel?

Excel summarizes the same information as follows:

1. Open the newly created Excel file.

2. Enter the required information after entering the interface.

3. Click Start, click Sort and Filter on the right, and then click Custom Sort in the menu that appears.

4. Select the main keyword in the pop-up page. If gender is the primary keyword, select column B and click OK.

5. The effect is as follows.

6. Sort by department as the main keyword, select column C, and sort in ascending order. Click OK.

7. The effect is as follows.