Parse JSON into using values as key

[leighp]

Happy Wednesday,

I cannot figure out how to parse a JSON so that everything gets sorted by one of the values instead of the keys.

When I compose the values from Power BI, I get:

(GB Status, BB Status both have the values Certified, In Progress, and Not Started)

When I use Parse JSON I use this Schema but the output does not appear to change.

{
  "type": "array",
  "items": {
    "type": "object",
    "properties": {
      "GB Status": {
        "type": "string"
      },
      "BB Status": {
        "type": "string"
      },
      "User Manager Name": {
        "type": "string"
      },
      "User Full Name": {
        "type": "string"
      }
    },
    "required": [
      "User Manager Name",
      "User Full Name"
    ]
  }
}

How do I get it so that instead of having the statuses as separate columns, that the names are organized by their values?

I.E.

instead of 

GB Status     BB Status       Full Name       Manager Name
Certified       In Progress      Joe                  Jane
In Progress   Not Started       Frank            Jane
Certified        Certified          Jack                John

It comes out as


GB Certified    GB In Progress     BB Certified     BB In Progress     Not Started (Only GB)
Joe                   Frank                    Jack                 Joe                          NAME

Jack                  NAME                  NAME              NAME                     NAME                             

(I also want to export this to CSV)