How to move values ​​to new lines by condition?

Question

SQL

Good afternoon. Ask for help from the community.
There is an array that needs to be spaced into different lines according to the condition, see the plate

Tried query, vlookup. I understand that just some algorithm can be applied.

An array of people with FLATTEN was deduced in one column, but I can’t think of how to bind the first two columns by condition.

Just in case, I'm attaching a screenshot.

Answer 1

From simple and unpretentious, you can try this

=ARRAYFORMULA(QUERY(
  SPLIT(FLATTEN(A1:A5& "|" & B1:B5 & "|" & C1:F5);"|");
  "where Col3<>''"
))