Pivot table from automation


how can i separate GL account from multiple sheets
image
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.

Thanks

Hi @Aparna_Reddy1,

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

With Regards,
Sanjit