Need to segregate the excel into multiple excels based on data

I need to segregate the excel in multiple excels.

  1. First The excel need to be segregated based on identity number
    2.If there is no identity number then the excel should be segregated based on bond number
    3.If the excel is divided based on identity number then sub divide the excel based on supplier number
    Have provided the required format in which output should be in excel sheets
    Exampleinput_reqs.xlsx (15.0 KB)


First, find the Unique Values from the Identity Number by following below

Now you can use For Row activity where you can use Filter Inside the For Each row activity and declare a tmp datatable

Now you can separate those data and you can use write range to write to the different sheets

Hope this may help you