Help with an Excel Formula

Maj786 

This assumes the pattern of 3 rows and 2 columns per scenario persists throughout the entire dataset.

= LET(
    statusRow, WRAPROWS(TOROW(statusBlock, 1), 4),
    scenarioStatus, BYROW(statusRow, LAMBDA(s,
      IFS(
        AND(s="PASS"), "PASS",
        OR(s="FAIL"), "FAIL",
        AND(s = "Not Run"), "Not Run",
        OR(s = "BLOCKED"), "Blocked",
        TRUE, "IN PROGRESS"
      )
    )),
    scenarioStatus
  )

From there you could populate your summary table or distribute the results to display them along with the scenario records.