Multiple metrics in one table panel

Hello Team,

I’ve created dashboard with Table Panel shown below which contains multiple metrics for servers based on Prometheus data source.
Labels are: Environment, Hostname
Metrics are: CPU usage, Memory usage, Disk C: usage

image

It was possible using Reduce transformation and Format=Table and Type=Instant Prometheus query options.

As such a query options are not available for Google Cloud Monitoring data source is it possible to achieve the same effect for this data source ?

I’ve tried various transformations combinations (Reduce + something) but with no success.
Here is what I’ve now with Reduce transformation,

image

but as you can see two rows show CPU usage value for two VM instances and next two Memory usage - all values in one column named Last, but what I want is to have 2 rows having those metrics in separate columns.

Anyone could help with that ?

Thanks in advance !

Ged