title: Split and repeat without
body: <p>In <a href="https://docs.google.com/spreadsheets/d/1DT_D897EGy2BGQC7G6XEzU98u-cm4s5pIp3p268Q9Q0/edit?usp=sharing" rel="nofollow noreferrer">this</a> sheet, I've the below input data:</p>
  <p><a href="https://i.stack.imgur.com/Jetgu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Jetgu.png" alt="enter image description here" /></a></p>
  <p>As seen, the <code>courses</code> are separated by <code>/</code></p>
  <p>I want to display the same in the format below, where each line shows one course only, with the data of the student repeated:</p>
  <p><a href="https://i.stack.imgur.com/rSLnE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rSLnE.png" alt="enter image description here" /></a></p>
  <p>I know using <code>=split(C3,&quot; / &quot;,true,true)</code> can split the courses into 2 columns at the same row, but I need them in the same column, so I tried <code>=TRANSPOSE(split(C3,&quot; / &quot;,true,true))</code> that is working fine for the first line only, but it fail with using <code>ARRAYFORMULA</code>.</p>
  <p>Any thought? I'm opened for any potential solution, formula or script or any other.</p>
  <p><strong>UPDATE</strong>
  I tried this trick, creating a new column showing number of courses for each student as <code>=ArrayFormula(LEN(REGEXREPLACE(C11:C13, &quot;[^/]&quot;, &quot;&quot;))+1)</code></p>
  <p><a href="https://i.stack.imgur.com/bl8im.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bl8im.png" alt="enter image description here" /></a></p>
  <p>Then using <code>Rep</code> to repeat each row based on the number of courses <code>=arrayformula({transpose(split(concatenate(rept(B11:B13 &amp; &quot;,&quot;,D11:D13)),&quot;,&quot;,false,true)),transpose(split(concatenate(REPT(C11:C13 &amp; &quot;,&quot;,D11:D13)),&quot;,&quot;,false,true))})</code> then ended up with:</p>
  <p><a href="https://i.stack.imgur.com/iccnv.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iccnv.png" alt="enter image description here" /></a></p>
  <p>But here, I've the courses still joint together, how can i split them!</p>