How to separte into multiple excel files from complex main excel

[Zaw_Win_Htun1 (Zaw Win Htun)]

Hello Experts,

I want to separate into multiple excel files from complex main excel file.
This is my main excel file as below:

I just want to separate into multiple excel files as below:

If there is any solutions or workaround for this topic, please let me know and feel free comment on it. Thanks. I will attach the excel file for better understanding.
test.xlsx (12.3 KB)

[Jose_Cunha (José Cunha)]

Hello.

The number of lines seems to me that it is not always the same…
Then you can do:

Create a datatable with the names of the columns you need;
Read the entire file using read range.
For each row, look for the value “NTV”… Whenever you find it, you have to save all the rows until the next value “NTV” or until the index of the last row with values + 1 (for the last table).

Hug

[saipraneethkumar.peyyeti (Venkata Peyyeti)]

Hello,

Please try the below attached workflow
forum_splitdatatable.zip (10.0 KB)

[Zaw_Win_Htun1 (Zaw Win Htun)]

Hello Venkata, thanks for sharing. It is the solution for my issue. Let me follow on you LinkedIn.

[saipraneethkumar.peyyeti (Venkata Peyyeti)]

Hello,

if it is solved your problem can you mark it as solution