If above Workbook Query related source excel file data is changed, and when you click Refresh menu item in above menu list, you can find the rows in new excel worksheet is also changed accordingly.You can right-click one query and then execute operations like edit, delete, rename, refresh etc in the popup menu list. It list all the queries that you have created. Now you can see your desired rows in the new worksheet left side, and there is also a Workbook Queries list pane in worksheet right side.After you edit the query condition, click the Power Query Editor‘s File -> Close & Load menu item to close the Power Query Editor and load the filtered out data rows into a new excel worksheet.You can click the down arrow at each column’s right side to open a popup window, and it provides sort, filter, compare functions in that window.You can execute sort, filter and other data clean actions in Power Query Editor to get the rows or columns data that you want. Click the Transform Data button will open the Power Query Editor window. ![]() In the Navigator window of import from excel file process, there is a Transform Data button after the Load drop-down list. ![]() ![]()
0 Comments
Leave a Reply. |