https://community.splunk.com/t5/Splunk-Search/How-to-Split-rows-into-columns/m-p/633980#M220192 <P>Thanks a lot!&nbsp;</P> Fri, 10 Mar 2023 02:57:20 GMT vik 2023-03-10T02:57:20Z https://community.splunk.com/t5/Splunk-Search/How-to-Split-rows-into-columns/m-p/633968#M220181 <P>I am trying to split the values in both the columns and create 5 rows by assigning respective values. I need an output as below. Can someone suggest how can I achieve this ?&nbsp;<BR /><BR />I tried mvexpand but it does not seem to help. Anything else we can try ?&nbsp;</P><P>&nbsp;</P><P>field1&nbsp; &nbsp; &nbsp; &nbsp;| field 2&nbsp;</P><P>-------------------------------</P><P>Name 1&nbsp; &nbsp;|&nbsp; 10</P><P>-------------------------------</P><P>Name 2&nbsp; &nbsp;| 12</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2023-03-09 at 5.14.59 PM.png"><img src="https://community.splunk.com/t5/image/serverpage/image-id/24273i5B393F3B9E72B107/image-size/medium?v=v2&amp;px=400" alt="Screen Shot 2023-03-09 at 5.14.59 PM.png" title="Screen Shot 2023-03-09 at 5.14.59 PM.png" /></span></P> Fri, 10 Mar 2023 00:22:10 GMT https://community.splunk.com/t5/Splunk-Search/How-to-Split-rows-into-columns/m-p/633968#M220181 vik 2023-03-10T00:22:10Z https://community.splunk.com/t5/Splunk-Search/How-to-Split-rows-into-columns/m-p/633970#M220183 <P>How about something like this?</P><LI-CODE lang="markup">| eval tmp_field = mvzip(field1, field2, "-|-") | fields - field1, field2 | mvexpand tmp_field | makemv delim="-|-" tmp_field | eval field1 = mvindex(tmp_field, 0) | eval field2 = mvindex(tmp_field, 1) | fields - tmp_field</LI-CODE><P>&nbsp;</P> Fri, 10 Mar 2023 00:42:51 GMT https://community.splunk.com/t5/Splunk-Search/How-to-Split-rows-into-columns/m-p/633970#M220183 Tom_Lundie 2023-03-10T00:42:51Z https://community.splunk.com/t5/Splunk-Search/How-to-Split-rows-into-columns/m-p/633980#M220192 <P>Thanks a lot!&nbsp;</P> Fri, 10 Mar 2023 02:57:20 GMT https://community.splunk.com/t5/Splunk-Search/How-to-Split-rows-into-columns/m-p/633980#M220192 vik 2023-03-10T02:57:20Z