Transform Rows into Column Table Data (Infinity Plugin)

Hello,

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

API endpoint used:
https://9498199887151372.hostedstatus.com/1.0/status/5d849b1c02e65b3ec45369d4

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.

Thanks,
Eugene