Table (A) includes names of 1000s of candidates applying to our program. This includes 20 columns with all their info. The final column has the decision “Accepted” or “Rejected”
I want to create a different table - let’s call it Table (B)- whereby it only includes the names of the “Accepted” candidates so that I can continue to track them on other metrics.
How can I get the first (or second) column in table B to check those tagged as “accepted” in table (a) and then list selected data points (e.g. their the names) in table B?
Any ideas how to do that?