How to import data that have 2 table in same sheet

[NabilahLoti]

I have similar input data like this. How to split this input and generate output data like this.

[ShankerV · Accepted solution]

Hi @NabilahLoti 

Please find the below expected output.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[NabilahLoti · Accepted solution]

Thank you @ShankerV . Hooray !, Its working 😁

[KrishnaChithrathil]

@NabilahLoti 

I know this post has already been solved. I'm posting my solution since I spent much time to solve this. 😄 I really enjoyed solving this.

To get a clear image of your scenario, I've made some changes in the input file. If you're checking this workflow, pls change it as required.

and the output: