Mimic Pivot - Locate Column Value (not unique)/Return Another Column Value (Summarized)

I have a formula similar to what I'm looking for, but I was curious if there was a better way. I don't know how to describe it other than it's mimicking a pivot table. I want to use this method rather than a pivot, because I'll be summarize lots of information on the same sheet and believe the pivot would be mostly single function.

My current formula looks like:

{=IF(SUMPRODUCT(IF('ALL'!$E$8:$E$900=$A9,'ALL'!K$8:K$900="X")*1)>=1,"X","")}

Also attached is the functionality I'm looking for, although it has no formulas in it. I'd love the second portion of the formula to be more similar to a Match that is looking for a specific value instead of the column count. That way I can set the value it's looking for to the column header like "Product A" in the example instead of Column A.

Hopefully this makes sense....thanks!

with PowerQuery
is that what you want?

from first "table" seems you've 3 X for Product A & Feature 1 so your second "table" is not a true

Sorry I wasn't very descriptive in my first post. The output table displays an X if there was one within the data table. Its the presence of the X not the count.

I'm not sure I understand how the output table isn't true. It's not dynamic using a formula, but the output table should be looking for any "Product A" rows that have a "X" for "Feature 1" and then places a "X" at that intersection within the output table. The formula posted above works (on a different data set), but I was trying to use something a bit easier to keep in sync. The formula up top uses column numbers (K vs L) but I would love to drive it off a variable in a cell like "Product A" or "Product B", so it doesn't matter what the order of the data or table is. It's always pulling the right information.

Added an additional table as another example. Thanks for the help.

this is exactly the same example as previous. only Data "table" and Output "table" - no less no more

Apologizes. Wrong file. Now attached.

something like this?