Filtering multiple columns of data into a new location

I have a large (1000's of rows, 100's of columns) data set that is like a validation of permissions. The different columns are the different roles in the organisation, but they start at column 14 as the first 13 columns contain the access descriptions listed vertically in the rows (1000's of them).
Thus the Yes/No/N/A data will start in cell N2.

The 13 columns describing the access is because of different modules, areas, focus areas etc.

What I need is a drop down list of the roles (N1:GA1) on a new sheet (which I can do) which, when each role is selected in turn from the drop down list, it will display the 13 column set of access descriptions for when that role has a Yes, and then underneath all of those, the 13 column set of access descriptions for when the role has No.

I've tried the filter function, but I can't make it work with choosing the role from the drop down list and displaying all 13 columns for each Yes row.
No idea what I'm doing

Any help would be much appreciated.
I've attached a dummy spreadsheet with hopefully clear comments about what I need.

Thanks in advance!

Works perfectly, thanks so much!

Thanks, being a new user, I wasn't aware, sorry, but I've have now 'added reputation' - is that right? Thanks again!
quick question, if , in my example sheet, some of the topics were blank, then the formula would show 0 in the place of any empty cell (see new attachment).
How do I get the 0 to just be a blank space?

Thanks heaps

fantastic, works exactly as I need it, you're a legend!
Thanks so much

Hi again,
Sorry to reopen the question, but I have another query.
Here is the formula I am using, with the choices of "Can Edit/Delete"; "Can View"; "Can Select" and "No Access"

=LET(data,IF(Sheet1!A2:M2649="","",Sheet1!A2:M2649),role,INDEX(Sheet1!O2:GB2649,0,MATCH(Sheet2!B1,Sheet1!O1:GB1,0)),VSTACK(FILTER(data,role="Can Edit/Delete"),HSTACK("","","","","","","","","","","","",""),FILTER(data,role="Can View"),HSTACK("","","","","","","","","","","","",""),FILTER(data,role="Can Select",FILTER(data,role="No Access"))))

It works exactly like I need it to, thanks again!

But, if I would like to colour code the responses (eg all the Can Edit/Delete filtered responses are red, all the Can View are yellow etc) how do I do that? I can't colour code the original list prior to filtering as different roles would have Can Edit/Delete or Can View or whatever.

Simple example using original worksheet uploaded has been included.

Is it a formula? conditional formatting?

Thanks in advance for your help - last question on this spreadsheet I swear!

Thanks so much! worked great. I did have to tweak the formula (my data has "can edit/delete", "can view", "can select" and "no access" instead of just "Yes" or "No"), but it is a thing of beauty!

One last question (sorry!!).
If I had, say for example, a managerial role over the top that covered Role 1 AND Role 2, is there a way to have a new filtered location (over in column Z for example) to show both sets of data?
See new sheet attached and scroll across to columns X onwards.

Thanks in advance for any help!

Hi, thanks for looking at this again for me. I would like both to start with.
So it will list all the Yes/No's for Role 1 and underneath all the Yes/No's for Role 2. So there will be some that is a Yes for one Role but a No for another.
Ultimately I need to know what permissions a role has, so there is a hierarchy - Yes outweighs No, so in terms of sorting and then removing duplicates, keep the Yes version of a Topic/Module/Area/Focus and not the No, so I have a final list of all the unique Yes's and No's that the Manager role has. Does that make sense?