Adding data to empty rows from above record.

Alteryx_user_aK

Hi,

I am getting a source file in below format

2023 | New York |M |2344.56|01012023
         |                 |G |343.56|01012023
         |                 |P |23474.56|01012023
         |                 |A |1000|01012023
         | Chicago   |B |2344.56|01012023
         |                 |   |888.34|02012023
         |                 |C |2345.56|02012023

But I want to generate output as per below 

2023 | New York |M |2344.56|01012023
2023 | New York |G |343.56|01012023
2023 | New York |P |23474.56|01012023
2023 | New York |A |1000|01012023
2023 | Chicago |B |2344.56|01012023
2023 | Chicago |B |888.34|02012023
2023 | Chicago |C |2345.56|02012023

How to achieve it ?

Thanks in advanced.

AK

ShankerV

Hi @Alteryx_user_aK 

A sample use case below for your scenario.

Many thanks

Shanker V

Adding data to empty rows from above record.yxmd