How to merge two rows into one ?

[marioosh2]

How to convert table like this (2 rows per topic):

topic   mbean_property_name bytes

A   BytesOutPerSec  60376267182

A   BytesInPerSec   12036381418

B   BytesInPerSec   6246693551

B   BytesOutPerSec  6237320887

to

topic   BytesOutPerSec  BytesInPerSec

A   60376267182 12036381418

B   6237320887 6246693551

[marioosh2]

Thank You very much 🙂

[VatsalJagani]

Hello @marioosh2 

I'm Vatsal from Community Moderator team,

If answer from @ITWhisperer resolved your question then please accept the answer by clicking on "Accept as Solution" underneath the answers from @ITWhisperer , so that future community member can get help from it.

[ITWhisperer · Accepted solution]

| xyseries topic mbean_property_name bytes