Filter field data

[oron89]

Hi,
i have the following Json content:
[
{
"id": "1",
"name": "test|app-dev|INFO",
"priority": "low",
"severity": 3,
"appName": "test-app",
"subName": "microservices-dev"
},
{
"id": "2",
"name": "test|app-dev|WARNING",
"priority": "medium",
"severity": 3,
"appName": "test-app",
"subName": "microservices-dev"
},
{
"id": "3",
"name": "test2|app-dev|CRITICAL",
"priority": "high",
"severity": 1,
"appName": "test2-app",
"subName": "microservices-dev"
}
]

and I want to present a table with data for each appName - priority per trace level, something like that:

appName	subName	WARNING	INFO	CRITICAL
test-app	microservices-dev	medium	low	null
test2-app	microservices-dev	null	null	high

Is it possible to implement something like that?
Is it possible to filter and extract the table header name from the value of "name"?
can I put the value from priority under the trace level header (debug,info, etc)?

Thank you!