json data transformation.

Hello All,

I have JSON data in the following format, which includes both columns and rows.

JSON Data:

{
"column": {
"id": "dropdown",
"title": "Product"
},
"id": "dropdown",
"text": "Financial Reporting"
}
{
"column": {
"id": "status",
"title": "Status"
},
"id": "status",
"text": "Not Started"
}

I can extract data for columns (

['column']['title'] = Product & Status

) and rows (

['column']['text'] = Financial Reporting & Not Started

) separately. However, my final output should look like the table below:

I have tried pivoting but with no success. Can someone please help me convert this into a table in KNIME?

Thank you!