how to select data from cell and copy to range until other data found open office calc
<p>There is the issue</p>

<p><a href="https://i.stack.imgur.com/6najw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6najw.png" alt="enter image description here"></a></p>

<p>I wonder if there is a way like if there is date(or text,e.g.) on B1 cell then copy B1 data to the range A2-A19, until the next cell with data (B20) and so goes on. Because on much data cannot be done by hand.</p>