Separate Excel into multiple sheets

Dear Experts.

I have the main excel file as the below:

And I want to separate the excel file into multiple sheets according to Travel type and for my scanerio there will be one excel sheet contains data from row 2 to row 4.

If the travel type data is one row after another, the excel sheet will be like this:

The condition will be based on two rules:
use the travel type column and read the data until it gets another data.

This is one excel sheet.
If the travel type column has data like this, there will be three excel sheets.

If there is any solution or work around, please let me know and share your sample workflow .Thanks.

will the grouping based on beneficiary name works?

No bro. If we used the beneficiary name as filter data, we have got the wrong data. Thanks.

is it possible to share the input excel?

sure bro. I will share the excel file.
Copy of Travel_v6.xlsx (25.6 KB)

hello bro. can u try the scanerio.

Hi @Zaw_Win_Htun1

This is not the optimized approach but will work. Please go through the xaml attached and let us know if it works for you.

SeparateDataIntoSheets.xaml (11.8 KB)

1 Like

yeah bro. It’s working well and if thre is any optimized solution, please share with me.
I’m okay with the current solution. Thanks bro. I’ll mark it as the solution.