Combine Excel Worksheets with Power Query
• Without using Match(), Index() and lookup() functions
• Better than Text-to-Column tool
◇ Text-to-Column tool can't update the output when new records are added
• Demo of Append and Groupby in Power Query Editor
• Refer to file “power_query_combine_bud_act” for step-by-step instructions
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Source
• https://www.myonlinetraininghub.com/combine-excel-worksheets-with-power-query
• https://youtu.be/wOVMJXfnQHk
Index