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

Hi CBWW - Yes Power Query can help, but I want to understand the following comment: "types of inventory feeding into an excel sheet".  How are you obtaining the data? 

If you, for example, the list was obtained from Database, you can simply create different Query to pull Red, Green, Orange.  If you are copying from one excel file to another, stop!  Just link Power Query to the other file.

Now load the separate tables into Separate worksheets.  As you do this you can include any functions like combining type and location in Power Query.

CBWW's avatar
CBWW
Frequent Visitor
3 years ago

Hi Daryl,

 

Thank you for the response. I'm populating my excel sheet by doing the following: Microsoft forms is filled out [Done]--> Power Automate --> feeds into Excel online document [Done]--> drawing the information from the excel online document to a Desktop excel document, where I can hopefully split up my data with Power query --> Use Power BI to create reports of our inventory across areas/items.