https://community.qlik.com/t5/QlikView/Cross-Table/m-p/1893488#M1217400 <P>I am having one column as 'A' and that column is having data in string such as 'abcdefgh 1.01.11,mnopqr 2.01.09' so i want to separate the value in two columns as 'B' which will contain values as 'abcdefgh' and 'mnopqr' and column 'A' will contain '1.01.11' and '2.01.09'.</P> <P>So i am using cross table to show the column values and it is getting displayed as,</P> <P>B&nbsp; &nbsp; &nbsp;abcdefgh</P> <P>B&nbsp; &nbsp; &nbsp;&nbsp;mnopqr</P> <P>A&nbsp; &nbsp; &nbsp;&nbsp;1.01.11</P> <P>A&nbsp; &nbsp; &nbsp; 2.01.09</P> <P>So I want to display the value in the cross table in this format how should i do?</P> <P>B&nbsp; &nbsp; &nbsp;abcdefgh</P> <P>A&nbsp; &nbsp; &nbsp;&nbsp;1.01.11</P> <P>B&nbsp; &nbsp; &nbsp;&nbsp;mnopqr</P> <P>A&nbsp; &nbsp; &nbsp; 2.01.09</P> Wed, 16 Feb 2022 05:59:57 GMT AbhishekGandhi23 2022-02-16T05:59:57Z https://community.qlik.com/t5/QlikView/Cross-Table/m-p/1893488#M1217400 <P>I am having one column as 'A' and that column is having data in string such as 'abcdefgh 1.01.11,mnopqr 2.01.09' so i want to separate the value in two columns as 'B' which will contain values as 'abcdefgh' and 'mnopqr' and column 'A' will contain '1.01.11' and '2.01.09'.</P> <P>So i am using cross table to show the column values and it is getting displayed as,</P> <P>B&nbsp; &nbsp; &nbsp;abcdefgh</P> <P>B&nbsp; &nbsp; &nbsp;&nbsp;mnopqr</P> <P>A&nbsp; &nbsp; &nbsp;&nbsp;1.01.11</P> <P>A&nbsp; &nbsp; &nbsp; 2.01.09</P> <P>So I want to display the value in the cross table in this format how should i do?</P> <P>B&nbsp; &nbsp; &nbsp;abcdefgh</P> <P>A&nbsp; &nbsp; &nbsp;&nbsp;1.01.11</P> <P>B&nbsp; &nbsp; &nbsp;&nbsp;mnopqr</P> <P>A&nbsp; &nbsp; &nbsp; 2.01.09</P> Wed, 16 Feb 2022 05:59:57 GMT https://community.qlik.com/t5/QlikView/Cross-Table/m-p/1893488#M1217400 AbhishekGandhi23 2022-02-16T05:59:57Z