Dependent lists based on multiple not unique table columns

Hi Guys,

i have table like here:

Screenshot_49.png

and i wnat to do dependent unique lists (drop downs) from left to right in seperate table for user input.

1. So in Division column i shouldhave just unique list based on division
2. If user will choose "Xbox" he will have in Drop down in column App = "Baden" and "Marko" (no duplicates!) as result to choose
3. If user will choose "Baden" - he will get only "4" in drop down in function column, if he will choose "Marko" he will get only "5" in function column in drop down lists.

Can anybody help how to build ?
Maybe pivot table?

Hmm please help,
Jacek