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.
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.