title: Google Sheet - Transform two columns into one column using arrayformula (more than 50,000 characters)
body: <p>I'm using Google Sheets and looking for an arrayformula that able to take a list in two columns and arrange it alternately in one column. The sheet contains about 5,000 rows, each row has more than 35 characters.</p>
  
  <p><a href="https://i.stack.imgur.com/cmErT.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cmErT.jpg" alt="enter image description here"></a></p>
  
  <p>I tried this:</p>
  
  <pre><code>=transpose(split(join(" ", query(transpose(B5:C),,50000)), " "))
  </code></pre>
  
  <p>But then I got this message:</p>
  
  <p><a href="https://i.stack.imgur.com/2KTnf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2KTnf.png" alt="enter image description here"></a></p>
  
  <p>Please take a look at the sheet here:</p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/11T1Roj1trviOSiiTZS292-4l3oODid7KLi9oGz3Z66o/edit#gid=0" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/11T1Roj1trviOSiiTZS292-4l3oODid7KLi9oGz3Z66o/edit#gid=0</a></p>