Display/Extract table content into a different table... possibly a Pivot?

[Dontcomehereoften]

Hi all,
So I have a table similar to the below which acts as a matrix, so Req ID 1 is in F1 but could be in any number of Fx, up to about F80.
The status of a Req ID can be updated
The Team X is the team who is interested/working on the particular Req.

Req ID	Status	F1	F2	F3	F4	F5
1​	Agreed	Team 1
2​	Rejected	Team 2
3​	Agreed		Team 3
4​	Rework			Team 2
5​	Draft		Team 3
6​	Agreed					Team 1
7​	Draft					Team 3

Ideally I would like to extract from the above, by Team (using Team 3 in example below) that shows something like the below where if Team 3 is in any Fx columns, show the Fx Number, the Req ID aligned to that entry and the Status of that Req ID;

Feature	Req ID	Status
F2	3	Agreed
F2	5	Draft
F5	7	Draft

VBA cannot be used due to policy and also can be easily refreshed as an when required. Is this possible?
Many thanks in advance

 

[Kerryx]

Power query to sort the data , export back into excel and filter by any team you want

Book2
	A	B	C	D	E	F	G
1	Req ID	Status	F1	F2	F3	F4	F5
2	1	Agreed	Team 1
3	2	Rejected	Team 2
4	3	Agreed		Team 3
5	4	Rework			Team 2
6	5	Draft		Team 3
7	6	Agreed					Team 1
8	7	Draft					Team 3
9
10
11	Attribute	Req ID	Status	Value
14	F2	3	Agreed	Team 3
16	F2	5	Draft	Team 3
18	F5	7	Draft	Team 3
Sheet1

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Req ID", type text}, {"Status", type text}, {"F1", type text}, {"F2", type text}, {"F3", type text}, {"F4", type any}, {"F5", type text}}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Req ID", "Status"}, "Attribute", "Value"),
    #"Reordered Columns" = Table.ReorderColumns(#"Unpivoted Other Columns",{"Attribute", "Req ID", "Status", "Value"})
in
    #"Reordered Columns"