Here’s the steps to join two rows in one row using transformation:
Step 1: Go to grafana dashboard and create new visualization.
Step 2: Now select your desired data source and choose your panel type
Step 3: Now select your both table
Step 4: Now go to transformation
Step 5: Now add concatenate fields transformation
Now you can see your both table is now joined
Final outcome: