Power query Help

[Just2431]

Hello,

I have query with data and i column contains criteria (staff and vendor), I want o seperate my data into 2 diffrent queries so I have data only for vendors and data for staff. How can I do this?

Thank you in advance!

[Just2431]

Thank you! I already figured it out after sending this message.. I duplicated the query and filter for vendor and the second one for staff..I didn't realized this was so easy. 

[lbendlin · Accepted solution]

right click on your query. Copy.  Right click in the empty area below. Paste.  Then apply the respective filters to each of the copies.