Sorting; While maintinaing some row associations, like a title.

M

Miyalo

I have some rows of data, with 2 columns. Column 1 contains task headings and
tasks, column 2 contains names.

Id like to be able to sort the data by row, but retain the titles in the
sorted list. Here is an example data set:

1 Title for this section
2 Sub-title for this section
3 Section Item Name1
4 Section Item Name2
5 Sub-title for this section
6 Section Item Name1

I would like to be able to sort the list, using Auto-Filter style drop
downs, by the Names column. Creating a result like this, for example if i
sorted by Name1:

1 Title for this section
2 Sub-title for this section
3 Section Item Name1
4 Sub-title for this section
5 Section Item Name1
 
Top