Multiple Filtering SPO List and displaying results in Connected Web Parts

Multiple Filtering SPO List and displaying results in Connected Web Parts I have a rather large list that was imported from excel. I was looking at an option (Page) where users can have multiple filters and then have the results displayed in a web part on the same page. I was hoping to have a page with 3 different web parts. The first where users could select an option from the second column, the results would be the corresponding line entries from the 6th column displayed in additional webpart, which users can filter again. Ideally I'd like for users to then be able to view columns 7, 8+9+10 (not in picture) etc displayed in a final web part. So in summary if this makes any sense theres 3 web parts, 2 of which are used for filtering and then the results displayed in the 3rd. The list itself has over 600 line items so its just a way for staff to check pricing on particular items (and have it nicely presented) without having to scroll through the list.