How to extract Subtables of a Main table

Hey guys,

I am working on Automating a desktop application, and I have a Main table and each row of the Main table can be expanded to Subtable. I want to loop through each row of the Main table and extract the Subtable of the corresponding Main table row. Any idea how can i do that?

Thanks & Regards

you can go with pivot tables activities ,
by that way you can easily solve that


Thanks for replying. I have not used Pivot table activities yet. Can you please explain a bit more or can you share a sample workflow? I am not working with excel files. I want to extract the sub-tables from a Windows form.

please go through this video

@anit.michael Is this problem solve already? If not can you please explain more?