Use Dataview to pull data from a table into a new table based on the column data

What I’m trying to do

I have a table of links as such:

| Name | URL | Type |
|example HR | | HR |
|example CS | https:/ | support |

I would like to be able to create other tables based on the data under the type column. i.e. list all the links that belong to HR.

Things I have tried

New to this and cannot get it to work at all.