Before a set of data is used for analysis, often additional effort is required to transform the data. Prior the introduction of Power Query, Macro/ VBA is often the answer. Now Power Query able to transform the data without involving the complexity of Macro/ VBA.
Power Query
WhyExcel™ PLT Office 6th Floor, Suite 16, IOI Business Park, Bandar Puchong Jaya, 47199 Puchong, Selangor.Before a set of data is used for analysis, often additional effort is required to transform the data. Prior the introduction of Power Query, Macro/ […]