I have following have the table with two rows per cart_id. for each secon row I want to replace Trolley_Start timestamp with the Begin_Picking timestamp and for each first row I want to replace Trolley_End timestamp with the End_Picking timestamp using Kusto Query language. Some guidance or help will be appriciated.
My Table is look like this:
I wanted this to be like this:
1