Group data by query

Grafana v8.2.3

I would like to group bar chart columns by separate queries. Much like how “filter data by query” works but instead of filtering, grouping the data into separate columns.

I have three queries that are gathering data from servicenow. Each of them return different stats on a table. I currently have three different panels displaying the data, but would like them to be displayed in one panel with one column per query. This seems like it would be a fairly popular request, but have found nothing on google to achieve this. Now, I know there is not an option in the transform tab, but is there a way to hack something together to achieve the same result?