Hello, I'm working on a simple table to compile different cost estimates from various engineering firms. I have different group headings such as ASPHALT, PIPING, STONE, etc. and then there are different items underneath those headings, all in column A. I want to sort everything alphabetically, but I don't know how to keep the items in each group with their appropriate categories. I want all the asphalt-related items to remain under the heading ASPHALT, but I want to be able to alphabetize by category and alphabetize within each category. Can anyone help?
Thanks!
Thanks!