Excel can let you sort your table in multiple levels. It's a little difficult to explain without showing you. So I have made a sample data we can all relate…