title: Can I merge multiple cells into one cell in Google Sheets with formula? (Example sheet provided)
body: <p>I have a spreadsheet with multiple items in individual cells (For example: all simpson family members 'Homer, Marge, Bart' etc all in C3, all spice girls in C5 etc).</p>
  <p>I want to split them up so they're one under the other in a list.</p>
  <p>Is their a way to do this for the entire column?</p>
  <p>My examples is <a href="https://docs.google.com/spreadsheets/d/1z3pnPCDEWewsHCpehrYMQ3QbZD8-GsfG_LFNFdQkP-M/edit?usp=sharing" rel="nofollow noreferrer">here</a> including what I want it to look like, and a test formula (=TRANSPOSE(SPLIT(C3, &quot;,&quot;))</p>