Trying to filter specific sets of data

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!

Please upload your workbook to the forum. Not all members are able - or willing - to access file hosting sites.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Thanks for the file

Perhaps you could include a few samples of your expected outcome?

Im not really sure what you want, but Im thinking that using a helper column (I used U, starting in U4), with this, will give you values that you can use to pull out data that matches your criteria...
=IF(AND(G4="ACD",G3="Ring"),U3+1,U3)
copied down

Thanks thats what I thought you wanted.

There is probably an ARRAY formula to do this, but this way works just as well, and may be more efficient, if you have a lot of data.

As I said in post #4, start with that helper column in the data sheet, U4, copied down...
=IF(AND(G4="ACD",G3="Ring"),U3+1,U3)

Then use this in Results L4, copied down and across...
=IFERROR(INDEX(data!$A:$T,MATCH(ROW(A1),data!$U:$U,0),MATCH(L$3,data!$A$3:$T$3,0)),"")
Format as needed