how to import rows that contain the same value more than once to another sheet-CodePudding

I have a list of sessions, I want to be able to import the ones that have been rescheduled (along with the new rescheduled session) to another sheet. So under colC one will say 'Rescheduled' and the other will say 'Attended'. So what I'd like to do is grab the participant name, but only if it shows up more than once, so I'd get both the rescheduled session and the new session. I tried using importrange and query, but couldn't quite get it right. How can I do this?

and if that's not enough:

=INDEX(REGEXREPLACE(SORT(TEXT(REGEXEXTRACT(FLATTEN(
 QUERY(QUERY(TRANSPOSE(QUERY(TRANSPOSE(QUERY({
 IMPORTRANGE("10ZWcO9DeBx6KjiyvFvcoBlGk7yw2b8z2gFPi26orOGc", "Sheet1!A1:C"), 
 FLATTEN(QUERY(TRANSPOSE(
 IMPORTRANGE("10ZWcO9DeBx6KjiyvFvcoBlGk7yw2b8z2gFPi26orOGc", "Sheet1!A1:C")),,9^9))}, 
 "select max(Col4) where Col1 is not null group by Col2 pivot Col3")), 
 "where Col1 matches 'Rescheduled|Attended'", )), 
 "where Col1 is not null and Col2 is not null"), 
 "offset 1", )), 
 "(\d /\d /\d ) (.*) (Att.*|Res.*)"), {
 "yyyymmdd\×m/d/yyyy", "@", "@"}), 2, 0, 1, 1), "^(\d ×)", ))

demo sheet