Forum Discussion

MyQueries's avatar
MyQueries
Copper Contributor
Sep 27, 2024
Solved

Data Transformation using VBA like subtotal

Hi All, I have excel file where I have approx. 38 columns but in order to create report I need only below mentioned headers from that report (approx 15 columns ). Logic :- 1) First remove all ...
Macros and VBA
MyQueries's avatar
MyQueries
Copper Contributor
Oct 01, 2024
Please try now

https://1drv.ms/x/s!Ap80Ku6M2Tw5g1lEf4e3NgpHZJBl?e=aIAEpM
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Oct 07, 2024

    Hi MyQueries 

    You're welcome & thanks for providing feedback
    Re. lot to learn in Power Query. This case isn't an easy exercise to start with

  • MyQueries's avatar
    MyQueries
    Copper Contributor
    Oct 07, 2024
    Hi Lorenzo,

    Thanks a lot , its working fine. lot to learn in Power Query.

Resources