Grafana table from Prometheus metric with key-value labels

I have a metadata metric in Prometheus that looks like this

# HELP metadata Process metadata
# TYPE metadata counter
metadata{hostname="server-a",key="version",value="v1.1.0"} 1
metadata{hostname="server-a",key="feature1",value="true"} 1
metadata{hostname="server-a",key="feature2",value="false"} 1
metadata{hostname="server-b",key="version",value="v1.0.0"} 1
metadata{hostname="server-b",key="feature1",value="false"} 1

where the key label has the name of the field and the value label has a string value. We don't care about the value of the metric, but it'll always be 1.

Is it possible to have Grafana format this as a table? i.e. like this

If I have a separate query (with Table format) for each possible key then I'm able to make it look like that with two transformations: an Outer join by hostname, then a Organize fields to remove the excess fields.

However, I'd like to do that without a separate query for each key, or even hardcoding key if possible. But despite all my fiddling with transforms I can't figure out how. There's also a couple of questions here that ask about similar things, but none of them do exactly what I'm looking for:

• Table-like visualization with label values as row values and column names which uses the actual metric value for the column values
• Grafana - create table with column values with Prometheus (dynamic) property/label data has each instance as a single metric with the right labels, instead of spread out over a number of metrics

And a few things that don't work

• A single query for metadata{} in table format has a column for the key and a column for the value, rather than column with the name of the key
• Closest I've gotten is with a Time series query then a Label to fields transformation, which has a column of 1s whose name is the value of key.

So is what I want even possible in Grafana?