Pivot with Crosstab or alternative?

  
jsonb_pretty

1
{
    "type": 17,
    "value": "",
    "children": [
        {
            "name": "co_area",
            "type": 0,
            "value": "de02",
            "children": [
            ]
        },
        {
            "name": "profit_ctr",
            "type": 0,
            "value": "0000001119",
            "children": [
            ]
        }
    ],
    "table_name": "profitcenterid"
}

2
{
    "type": 17,
    "value": "",
    "children": [
        {
            "name": "co_area",
            "type": 0,
            "value": "de02",
            "children": [
            ]
        },
        {
            "name": "profit_ctr",
            "type": 0,
            "value": "0000001120",
            "children": [
            ]
        }
    ],
    "table_name": "profitcenterid"
}