Need help or advise : Build data to write rage

Dear Developer,
i have raw data and expected need to write range as below pic.
i don’t have no idea to handle. could you please help or advise.
thank you so much.


Hi, you will need to do a read range, then in a For Each implement the logic as you need, maybe will be easier if you create first a new datatable for the results, and keep adding to it instead of trying to fix the source one, in the end you can write range over in a new sheet or new excel even.