title: How to split topics and contents into multiple rows?
body: <p>I have a case with the underlying information. I would like to transpose the following which worked with the help of the WebAppStackExchange link, however, it doesn't split the names of the projects. </p>
  
  <pre><code>Project A | Jan, Feb, Mar 
  Project B | Mar, Apr, Jun, Jul
  Project C | Jan, Feb
  </code></pre>
  
  <p>I have been referring to this page and it helped a lot: </p>
  
  <p><a href="https://webapps.stackexchange.com/questions/39822/split-content-of-one-row-into-multiple-rows">https://webapps.stackexchange.com/questions/39822/split-content-of-one-row-into-multiple-rows</a></p>
  
  <p>This is an example code from the StackExchange which worked for me. </p>
  
  <pre><code>=TRANSPOSE (SPLIT(REPT(CONCAT(B1; ","); COUNTA(B1:B3)); ","))
  </code></pre>
  
  <p>This is the ideal result: </p>
  
  <pre><code>Project A | Jan
  Project A | Feb
  Project A | Mar
  Project B | Mar
  Project B | Apr 
  Project B | Jun
  Project B | Jul
  Project C | Jan
  Project C | Feb
  </code></pre>