Separte excel into multiple sheets

Learning Initatives Automation Starter
, ,
1

Dear Experts,

I want to separate the excel into multiple sheets according to the following rules:

image
image1625×266 189 KB

I have the above main excel sheet and I want to separate like the following:
image
image1200×135 69.9 KB

image
image1172×144 69.4 KB

image
image1090×100 42.6 KB

image
image1091×148 40.4 KB

If the excel cells ‘Payment Date’ are merged, all the records are spearated into one sheet and if the cell are not unmerged, the record is also separated into one excel sheet.
If there is any solution or workaround, please let me know.

2

Hey,

You can use the switch Activity On the Basis of First Column i.e Payment Date
then you can use Append Range Activity For Appending Data

Tahnks,
Rounak

3

Dear Rounak, can you please give me the sample workflow for your answer.
Thanks.

4

Hey,
you can follow this workflow,
Sample1.xlsx (8.7 KB)
Sample3.xaml (9.8 KB)
Please let me know. if you get expected output
Thanks,
Rounak

5

Hey,

Please confirm you are getting expected Output which
i attached the workflow for your Reference.

Thanks,
Rounak

6

Hi bro. This is not the solution I want.

7

Hey
I have given you the reference, not the exactly as per your file.
Please take a reference and do modification.
Thanks