topic Re: Table multiple data in one cell in Splunk Search https://community.splunk.com/t5/Splunk-Search/How-do-I-table-multiple-data-into-one-cell/m-p/611478#M212602 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/248809">@fperalde</a>,</P><P>good for you, see next time!</P><P>Ciao and happy splunking</P><P>Giuseppe</P><P>P.S.: Karma Points are appreciated <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P> Wed, 31 Aug 2022 15:52:56 GMT gcusello 2022-08-31T15:52:56Z How do I table multiple data into one cell? https://community.splunk.com/t5/Splunk-Search/How-do-I-table-multiple-data-into-one-cell/m-p/611468#M212598 <P>Hello I have a little problem with Splunk! I have a table that basically contains data in the following way</P> <TABLE> <TBODY> <TR> <TD> <P>number</P> </TD> <TD> <P>value</P> </TD> </TR> <TR> <TD> <P>1</P> </TD> <TD> <P>A</P> </TD> </TR> <TR> <TD> <P>1</P> </TD> <TD> <P>B</P> </TD> </TR> <TR> <TD> <P>2</P> </TD> <TD> <P>C</P> </TD> </TR> <TR> <TD> <P>3</P> </TD> <TD> <P>D</P> </TD> </TR> <TR> <TD> <P>3</P> </TD> <TD> <P>E</P> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I would like to have a table like</P> <TABLE> <TBODY> <TR> <TD> <P>number</P> </TD> <TD> <P>value</P> </TD> </TR> <TR> <TD> <P>1</P> </TD> <TD> <P>A</P> <P>B</P> </TD> </TR> <TR> <TD> <P>2</P> </TD> <TD> <P>C</P> </TD> </TR> <TR> <TD> <P>3</P> </TD> <TD> <P>D<BR />E</P> </TD> </TR> </TBODY> </TABLE> <P>As you can see, I would like to have the data in the same cells.</P> <P>&nbsp;</P> <P>If you have a solution&nbsp; <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Wed, 31 Aug 2022 14:53:58 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-table-multiple-data-into-one-cell/m-p/611468#M212598 fperalde 2022-08-31T14:53:58Z Re: Table multiple data in one cell https://community.splunk.com/t5/Splunk-Search/How-do-I-table-multiple-data-into-one-cell/m-p/611469#M212599 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/248809">@fperalde</a>,</P><P>you have to use the stats command with the value option, something like this:</P><LI-CODE lang="markup">&lt;your_search&gt; | stats values(value) AS value BY number</LI-CODE><P>Ciao.</P><P>Giuseppe</P> Wed, 31 Aug 2022 14:44:52 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-table-multiple-data-into-one-cell/m-p/611469#M212599 gcusello 2022-08-31T14:44:52Z Re: Table multiple data in one cell https://community.splunk.com/t5/Splunk-Search/How-do-I-table-multiple-data-into-one-cell/m-p/611478#M212602 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/248809">@fperalde</a>,</P><P>good for you, see next time!</P><P>Ciao and happy splunking</P><P>Giuseppe</P><P>P.S.: Karma Points are appreciated <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P> Wed, 31 Aug 2022 15:52:56 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-table-multiple-data-into-one-cell/m-p/611478#M212602 gcusello 2022-08-31T15:52:56Z