How to merge columns with the same name

Grafana Dashboards
1

Hi guys,

I already spent a lot of time to figure out this, but still have no solution.
I want to join query from Prometheus and Google Sheet. This is the Prometheus metric:

{__name__="k6_http_req_duration_*"}

I use label to fields transformation and outer join transformation, but I got duplicating columns with like this:

image
image1068×175 7.53 KB

Is there any solutions to join this two queries without duplicating columns?
Thanks a lot in advance

2

so you have two queries in the same panel? can you share the raw data for each?

Can you inspect your raw request and response and then share it in a code-block?

Can you use the data tab inside the Grafana Inspector panel to share your data?