How to create a View containing unique values from column in slice or table.

[estock]

I have a table in my database the contains a column called "Vertical" . Let's say for instance that  that there are 25 verticals. I looking for a way to populate a view listing those 25 verticals uniquely ( without having to create an additional table containing just the  verticals ) , than I want to then link each row to another view that shows only the rows containing that particular vertical. Can't quite figure out how to do this within the App-sheet ecosystem.

For further illustration lets say this is my table 

Vertical 1	Other info 1	Key 1
Vertical 1	Other info 2	Key 2
Vertical 2	Other info 3	Key 3
Vertical 3	Other info 4	Key 4
Vertical 3	Other info 5	Key 5

and I want to filter the data so it look like this 

Vertical 1	Other info 1	Key 1
Vertical 2	Other info 3	Key 3
Vertical 3	Other info 5	Key 5

[koma25]

will this help? 

[estock]

Thanks, not exactly looking for something more like this, if my data looks as such 

Vertical 1	Other info 1	Key 1
Vertical 1	Other info 2	Key 2
Vertical 2	Other info 3	Key 3
Vertical 3	Other info 4	Key 4
Vertical 3	Other info 5	Key 5

I just want  the unique rows 

Vertical 1	Other info 1	Key 1
Vertical 2	Other info 3	Key 3
Vertical 3	Other info 4	Key 4

[koma25 · Accepted solution]

create a virtual column with the formula: 

IFS(

([_THISROW] = MAXROW("table name", "_ROWNUMBER", ([_THISROW].[Vertical] = [Vertical],))),True

)

You can use it in slice, show rows  where virtual column =true