Power Query - Move row to new tab

Question

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 inventory feeding into an excel sheet. Types: Red, Orange, Green. I have created Common ID's based on the Location our inventory is going to and the type of inventory it is. Common ID's: AlaskaGreen, FloridaRed, AlaskaRed, FloridaOrange. The Common ID's are in one column and the Types are in another column, along with other descriptive columns such as count.

Question:
What I am trying to do is move rows to new excel tabs based on either the item type or based on the Common ID. Essentially I just want to separate the Reds rows into their own sheet or the Alaska's rows to their own sheet. All of this I am trying to do automatically once the master excel sheet is updated. Is this possible? I think part of the confusion may be in an incomplete understanding of what it is I am using. It seems likely that there is a way to do this, but I'm not sure there is a way to do it automatically. I am hoping that Power Query is the solution.

Answer 1

Power query is not currently supported here on Q&A. The product group for Power Query actively monitors questions over at
https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services

--please don't forget to Accept as answer if the reply is helpful--