Transform Rows into Column Table Data (Infinity Plugin)


I’m trying to transform table data using the Infinity plugin as the main datasource (Grafana version 9.1.7).

API endpoint used:

Current table view is as follows:

We would like to represent the data as follows:
name (column 1) | status (column 2)
unique values from the column 2 | Operational status

Please find the current configurations set up and highly appreciate if you could advise which particular transformations can be used in this case.