I need to segregate the excel in multiple excels.
- 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)