Pivot table from automation

how can i separate GL account from multiple sheets

can anyone see this i need this type of pivot table can anyone help me this

Hi @Aparna_Reddy1,

This can be achieved using LinQ, Can you please tell us the rules you want to apply on your input sheet/ the rules by which you have achieved this Pivot table.


Hi @Aparna_Reddy1,

Kindly go through the link it will help you to create the pivot using linq.

With Regards,