Trying to filter specific sets of data

[klturi421]

I am working with a file that has 10 columns with varied data in each one. There is only one column that has (fairly) consistent data. I will attach the file so that hopefully it will help with what I am trying to do.

I want to have the unique values copy over to another worksheet. There are multiple ACD options, but I only want ACD to be copied IF the cell above it contains the value RING. Additionally, I would like to copy over the first TIME column, if possible the second. If necessary I will have a macro change the names to the second column to length.

Data-file.xlsx

I know that advanced filters can be utilized but I have not yet been able to figure out how to properly set it up.

Any tips would be greatly appreciated!