title: LibreOffice calc | How can I bring all entries of different rows into one column?
body: <p>I have a lot of different column entries per row. And thousands of rows.</p>
  <p>Example ( &quot;|&quot; starts a new column)</p>
  <blockquote>
  <p>1st row: car | wash | shirt</p>
  <p>2nd row: house | roof</p>
  <p>3rd row: human | animal | technic | plant</p>
  <p>...</p>
  </blockquote>
  <p>How can I bring all entries of different rows into one column?</p>
  <p>Example</p>
  <blockquote>
  <p>car</p>
  <p>wash</p>
  <p>shirt</p>
  <p>house</p>
  <p>roof</p>
  <p>...</p>
  </blockquote>