How to split particular range row and update value in each split in excel

Closed as a duplicate of this one here: How to grouping excel data to send to API