Select any cell in Table1 > go to the Power Query tab (Excel 2016 Data tab) > From Table. Step 1: Load the tables into Power Query. Power Query for Excel 20 Office 365 is only available with Office 365 ProPlus and Enterprise licences. In Excel 2016 it’s available on the Data tab in the Get & Transform group. *Power Query is available in desktop versions of Excel 20 as a free add-in which you can download here. Tip: I recommend you format your lists in an Excel Table before loading into Power Query. We can use Power Query* to easily compare two lists like these staff lists below:įor referencing purposes in this tutorial I’ve formatted the names that are different in each list above in red. Excel for Customer Service ProfessionalsĪ common task in Excel is to compare two lists to identify which items are duplicates, different or missing from one list compared to the other.
0 kommentar(er)
