topic Re: How to merge two rows into one ? in Splunk Search https://community.splunk.com/t5/Splunk-Search/How-to-merge-two-rows-into-one/m-p/687313#M234433 <P>Thank You very much <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Mon, 13 May 2024 10:30:24 GMT marioosh2 2024-05-13T10:30:24Z How to merge two rows into one ? https://community.splunk.com/t5/Splunk-Search/How-to-merge-two-rows-into-one/m-p/687306#M234430 <DIV><DIV><SPAN>How to convert table like this (2 rows per topic):</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>topic &nbsp; mbean_property_name bytes</SPAN></DIV><DIV><SPAN>A &nbsp; BytesOutPerSec &nbsp;60376267182</SPAN></DIV><DIV><SPAN>A &nbsp; BytesInPerSec &nbsp; 12036381418</SPAN></DIV><DIV><SPAN>B &nbsp; BytesInPerSec &nbsp; 6246693551</SPAN></DIV><DIV><SPAN>B &nbsp; BytesOutPerSec &nbsp;6237320887</SPAN></DIV><BR /><DIV><SPAN>to </SPAN></DIV><DIV><SPAN>topic &nbsp; BytesOutPerSec &nbsp;BytesInPerSec</SPAN></DIV><DIV><SPAN>A &nbsp; 60376267182 12036381418</SPAN></DIV><DIV><SPAN>B &nbsp; 6237320887 6246693551</SPAN></DIV><BR /><BR /></DIV> Mon, 13 May 2024 09:24:10 GMT https://community.splunk.com/t5/Splunk-Search/How-to-merge-two-rows-into-one/m-p/687306#M234430 marioosh2 2024-05-13T09:24:10Z Re: How to merge two rows into one ? https://community.splunk.com/t5/Splunk-Search/How-to-merge-two-rows-into-one/m-p/687309#M234432 <LI-CODE lang="markup">| xyseries topic mbean_property_name bytes</LI-CODE> Mon, 13 May 2024 09:59:49 GMT https://community.splunk.com/t5/Splunk-Search/How-to-merge-two-rows-into-one/m-p/687309#M234432 ITWhisperer 2024-05-13T09:59:49Z Re: How to merge two rows into one ? https://community.splunk.com/t5/Splunk-Search/How-to-merge-two-rows-into-one/m-p/687313#M234433 <P>Thank You very much <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Mon, 13 May 2024 10:30:24 GMT https://community.splunk.com/t5/Splunk-Search/How-to-merge-two-rows-into-one/m-p/687313#M234433 marioosh2 2024-05-13T10:30:24Z Re: How to merge two rows into one ? https://community.splunk.com/t5/Splunk-Search/How-to-merge-two-rows-into-one/m-p/687374#M234440 <P>Hello&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/267834">@marioosh2</a>&nbsp;</P><P>I'm Vatsal from Community Moderator team,</P><P>If answer from&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/225168">@ITWhisperer</a>&nbsp;resolved your question then please accept the answer by clicking on "Accept as Solution" underneath the answers from <a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/225168">@ITWhisperer</a>&nbsp;, so that future community member can get help from it.</P><P>&nbsp;</P> Mon, 13 May 2024 18:42:17 GMT https://community.splunk.com/t5/Splunk-Search/How-to-merge-two-rows-into-one/m-p/687374#M234440 VatsalJagani 2024-05-13T18:42:17Z