Hi Team,
I have the following data:
| Data | Parsed_Page_Number | Tile_Num |
| Text1 | [Null] | 1 |
| Text2 | 1 | 2 |
| Text3 | [Null] | 1 |
| Text4 | 2 | 2 |
| Text5 | [Null] | 1 |
| Text6 | 3 | 2 |
| Text7 | [Null] | 1 |
| Text8 | 4 | 2 |
| Text9 | [Null] | 1 |
| Text10 | 5 | 2 |
and would want to create a new column ('Real_Page_Number') with page numbers driven off of 'Parsed_Page_Number' column. As you might have noticed, 'Parsed_Page_Number' with nulls belong to the same population of a page number following it. For example, Text1 and Text2 belong to page 1 even though 'Parsed_Page_Number' is null for Text1.
| Data | Parsed_Page_Number | Tile_Num | Real_Page_Number |
| Text1 | [Null] | 1 | 1 |
| Text2 | 1 | 2 | 1 |
| Text3 | [Null] | 1 | 2 |
| Text4 | 2 | 2 | 2 |
| Text5 | [Null] | 1 | 3 |
| Text6 | 3 | 2 | 3 |
| Text7 | [Null] | 1 | 4 |
| Text8 | 4 | 2 | 4 |
| Text9 | [Null] | 1 | 5 |
| Text10 | 5 | 2 | 5 |
Many thanks in advance to anyone who will try to help!
