title: BigQuery split array into individual rows
body: <p>In BigQuery I have done a <code>REGEXP_EXTRACT_ALL</code> query and have results where each row contains multiple lines (an array).</p>
  
  <p>How can query this table to convert each row's array into its own row so that my resulting table is individual rows of each line, instead of an array? </p>