1. When filtering in an Excel file for “揭美娜”, the filter only applies up to the row with the date 4.30; the rows after that cannot be filtered successfully. See Figure 1 and Figure 2.
2. I noticed that in the row with the date 5.1, every column has a filter button, making it seem like a new table has started. See Figure 3.
3. A new row is started in the first table, and the sequence numbers continue. See Figure 4.
4. I finally decided to cut all rows starting from the row with the date 5.1, excluding the sequence number column. See Figure 5.
5. Then I pasted them starting from the date column of the new row. See Figure 6.
6. I found that the filter buttons in the row with the date 5.1 have disappeared. Filtering for “揭美娜” is successful and meets expectations. See Figure 7.
