@NMattoon_22 You can use a Pivot Table for this by selecting the original table and Insert -> PivotTable and then select needs contract as the filter and select the columns you want to display.
You can also recreate it using FILTER() function.
where "col1:col1" is the proper reference to that column (e.g. "A:A" or "Table1[s_ID]")
if you include a sample sheet it would be easy to show you.