<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
On 3/28/2021 2:05 PM, Alexandre Neto wrote:
<blockquote type="cite">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="auto">Sorry,
<div dir="auto"><br>
</div>
<div dir="auto">Can you be more clear? It's not clear to me what
you are trying to accomplish.</div>
<div dir="auto"><br>
</div>
<br>
</div>
</blockquote>
Here's some sample data he posted on Github:<br>
<br>
<table width="338" cellspacing="0" cellpadding="0" border="0">
<colgroup><col
style="mso-width-source:userset;mso-width-alt:4573;width:101pt"
width="134"> <col style="width:51pt" width="68" span="3"> </colgroup><tbody>
<tr style="height:14.25pt" id="file-fill_down-csv-LC1"
height="19">
<td class="xl65" style="height:14.25pt;width:101pt"
width="134" height="19">data</td>
<td class="xl65" style="width:51pt" width="68">nuts2</td>
<td class="xl65" style="width:51pt" width="68">zona</td>
<td class="xl65" style="width:51pt" width="68">zona_fill</td>
</tr>
<tr style="height:28.5pt" id="file-fill_down-csv-LC2"
height="38">
<td class="xl66" style="height:28.5pt;width:101pt" width="134"
height="38">2020-11-09T17:00:00</td>
<td class="xl66" style="width:51pt" width="68">ITF1</td>
<td class="xl66" style="width:51pt" width="68"><br>
</td>
<td class="xl66" style="width:51pt" width="68"><br>
</td>
</tr>
<tr style="height:28.5pt" id="file-fill_down-csv-LC3"
height="38">
<td class="xl66" style="height:28.5pt;width:101pt" width="134"
height="38">2020-11-10T17:00:00</td>
<td class="xl66" style="width:51pt" width="68">ITF1</td>
<td class="xl66" style="width:51pt" width="68">arancione</td>
<td class="xl66" style="width:51pt" width="68">arancione</td>
</tr>
<tr style="height:28.5pt" id="file-fill_down-csv-LC4"
height="38">
<td class="xl66" style="height:28.5pt;width:101pt" width="134"
height="38">2020-11-11T17:00:00</td>
<td class="xl66" style="width:51pt" width="68">ITF1</td>
<td class="xl66" style="width:51pt" width="68"><br>
</td>
<td class="xl66" style="width:51pt" width="68">arancione</td>
</tr>
<tr style="height:28.5pt" id="file-fill_down-csv-LC5"
height="38">
<td class="xl66" style="height:28.5pt;width:101pt" width="134"
height="38">2020-11-12T17:00:00</td>
<td class="xl66" style="width:51pt" width="68">ITF1</td>
<td class="xl66" style="width:51pt" width="68"><br>
</td>
<td class="xl66" style="width:51pt" width="68">arancione</td>
</tr>
<tr style="height:28.5pt" id="file-fill_down-csv-LC6"
height="38">
<td class="xl66" style="height:28.5pt;width:101pt" width="134"
height="38">2020-11-20T17:00:00</td>
<td class="xl66" style="width:51pt" width="68">ITF1</td>
<td class="xl66" style="width:51pt" width="68"><br>
</td>
<td class="xl66" style="width:51pt" width="68">arancione</td>
</tr>
<tr style="height:28.5pt" id="file-fill_down-csv-LC7"
height="38">
<td class="xl66" style="height:28.5pt;width:101pt" width="134"
height="38">2020-11-21T17:00:00</td>
<td class="xl66" style="width:51pt" width="68">ITF1</td>
<td class="xl66" style="width:51pt" width="68"><br>
</td>
<td class="xl66" style="width:51pt" width="68">arancione</td>
</tr>
<tr style="height:28.5pt" id="file-fill_down-csv-LC8"
height="38">
<td class="xl66" style="height:28.5pt;width:101pt" width="134"
height="38">2020-11-22T17:00:00</td>
<td class="xl66" style="width:51pt" width="68">ITF1</td>
<td class="xl66" style="width:51pt" width="68">rossa</td>
<td class="xl66" style="width:51pt" width="68">rossa</td>
</tr>
<tr style="height:28.5pt" id="file-fill_down-csv-LC9"
height="38">
<td class="xl66" style="height:28.5pt;width:101pt" width="134"
height="38">2020-11-23T17:00:00</td>
<td class="xl66" style="width:51pt" width="68">ITF1</td>
<td class="xl66" style="width:51pt" width="68"><br>
</td>
<td class="xl66" style="width:51pt" width="68">rossa</td>
</tr>
<tr style="height:28.5pt" id="file-fill_down-csv-LC10"
height="38">
<td class="xl66" style="height:28.5pt;width:101pt" width="134"
height="38">2020-11-24T17:00:00</td>
<td class="xl66" style="width:51pt" width="68">ITF1</td>
<td class="xl66" style="width:51pt" width="68"><br>
</td>
<td class="xl66" style="width:51pt" width="68">rossa</td>
</tr>
<tr style="height:28.5pt" id="file-fill_down-csv-LC11"
height="38">
<td class="xl66" style="height:28.5pt;width:101pt" width="134"
height="38">2020-12-04T17:00:00</td>
<td class="xl66" style="width:51pt" width="68">ITF1</td>
<td class="xl66" style="width:51pt" width="68"><br>
</td>
<td class="xl66" style="width:51pt" width="68">rossa</td>
</tr>
<tr style="height:28.5pt" id="file-fill_down-csv-LC12"
height="38">
<td class="xl66" style="height:28.5pt;width:101pt" width="134"
height="38">2020-11-09T17:00:00</td>
<td class="xl66" style="width:51pt" width="68">ITF5</td>
<td class="xl66" style="width:51pt" width="68"><br>
</td>
<td class="xl66" style="width:51pt" width="68">rossa</td>
</tr>
</tbody>
</table>
<br>
the column labeled "zona" has entries followed by some number of
blank entries.<br>
I believe he wants to create a column "zona_fill" that contains the
last non-blank entry in "zona" that's above or equal the current
row.<br>
<br>
<br>
</body>
</html>