Filter or Formula to export into different worksheets

[geeklarokcmie]

For the below data - I'd like to use a filter or formula for the input data and have the desired output:

(Please note the the values in browser/application columns may be (alphanumeric with special characters)

Input

Issues	browser/application	Owner
1	Chrome	Google
2	FireFox	mozilla
3	Edge	microsoft
4	IE	Microsoft
5	powerapps	microsoft
6	drive	google
7	safari	apple

Output

Issues	browser/application	Owner
1	Chrome	Google
2	FireFox	mozilla
5	powerapps	microsoft
6	drive	google
7	safari	apple

Once the above is achieved I'd like to output the data into separate worksheets - an example below:

Worksheet 1

Issues	browser/application	Owner
3	Edge	microsoft
4	IE	Microsoft
5	powerapps	microsoft

Worksheet 2 

Issues	browser/application	Owner
1	Chrome	Google
6	drive	google

[geeklarokcmie]

Thank you so much. Your below workflow worked for. 

Another query - I need to get all the all the applications by the owner "jane doe" and "jill doe" along with only few applications such as "chrome" "snapchat" and "powerapps" by the owner "john doe"

Can you explain me why the below IF formula doesn't work for the above query? 

IF Contains([Application], "Chrome") THEN "Chrome"
Elseif Contains([Application], "snapchat") THEN "snapchat"
elseIF Contains([application], "powerapps") THEN "powerapps"
Else [Application] endif

[binuacs · Accepted solution]

@geeklarokcmie Your formula assigning a value instead of filtering

[Owner] IN ("jane doe","jill doe")
OR
(
   [Owner] IN ("john doe") 
   AND 
     (Contains([Application], "Chrome")
   OR
    Contains([Application], "Drive")
   OR
  Contains([Application], "SnapChat")
))

[geeklarokcmie]

@binuacs  Appreciate your expert help in this matter. Thank you. Workflow is perfect now.