Forum Discussion

CBWW's avatar
CBWW
Frequent Visitor
3 years ago

Power Query: Move row to new tab

Hello, I have not used Power Query before today and am trying to figure out if Power Query is what I should be using/if so, how to do what I am trying to do.   Context: I have various types of inv...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Yes you can.  You will link to the Excel Online document to get the results from the Form.  I would consider switch from Excel Online file to csv file in SharePoint.  Power Query can read csv file faster than excel file.  It is easier to link to and import files via SharePoint.Files connector.  Leave any of the excel transformation and function to Power Query.  In Power Query, use the Reference and Filter feature.  It petty much like using Excel, but everything is recorded in the Query Applied Steps.

CBWW's avatar
CBWW
Frequent Visitor
3 years ago

Thank you! I will look into switching to Sharepoint. Just for clarity: I have imported my file into excel desktop, Query 1. I have selected reference  and filtered text under the appropriate column, for example cells that contain 'red'. I click Close & Load then what is being produced just says: externalData_2, ExternalData_3, etc..., in the top left cell of each new tab that is generated.