Sorting a Table that Contains Merged Cells
If a table contains cells that span over multiple rows, you can not perform the sorting operation over the entire table. Still, the sorting mechanism works over a selection of rows that do not contain rowspans.
Note
For this type of table, the
                  Sort dialog box keeps the All rows option
                  disabled even if you perform the sorting operation over a selection of rows.
               
            