Filtering detail table based on selection in summary table in Orange 3.11
A workflow like this might do the trick, although it is static (does not adjust to varying actions).


Load the two files, Summary and Details.
I suppose "Details" has columns such as "Action" and some value. In my example, Details will contain "Subject" and "Grade" for 3 highschool subjects.
"Select columns" is optional (slim down unused columns)
You need a "Select rows" for each subject/action, filtering that specific one.
Every "Edit Domain" is used to rename the generic feature name to a specific on (like "Grade" to "Grade_Math").
Results are then merged step-wise to the Summary (which in my example contains students, your summary contains some other people).


If the number of actions is limited, the time needed is reasonable.

If this is a one-time job, you might as well save the output (CSV) and use that in a different project.

If it needs to be more dynamic and adaptive, you'll have to dig into Python and use the Python code widget to create a list of actions, create a list of columns based on that, and then populate those with matching values.