Hello Experts,
Following is the data available in a table, only Line Item 1 is having data in Cleared On , Cleared Doc fields.
The remaining line items have blanks values in Cleared On , Cleared Doc fields.
I need to create a CDS VIew such that it should use / copy the same values of Cleared On , Cleared Doc fields of Line item 1 to Line item 2 , Line item 3 , Line item 4.

i.e.
For Line item 2, Line item 3, Line item 4
All the Blank fields in Cleared on column should be filled / copied from Line Item 1 with 01-Sep-23,
All the Blank fields in Cleared Doc column should be filled / copied from Line Item 1 with 2001,
Expected outcome of CDS view should be as shown.

Thanks,
Vijay