topic Re: Splitting Multiple entries into different columns in QlikView https://community.qlik.com/t5/QlikView/Splitting-Multiple-entries-into-different-columns/m-p/907584#M652316 <HTML><HEAD></HEAD><BODY><P>welcome!!!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/cool.png" /></P></BODY></HTML> Mon, 03 Aug 2015 07:12:07 GMT senpradip007 2015-08-03T07:12:07Z Splitting Multiple entries into different columns https://community.qlik.com/t5/QlikView/Splitting-Multiple-entries-into-different-columns/m-p/907581#M652313 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P></P><P>I have a data in below format:</P><P></P><TABLE><TBODY><TR><TD>Invoice No.</TD><TD>Scheme Code</TD></TR><TR><TD>121</TD><TD>A01</TD></TR><TR><TD>121</TD><TD>A02</TD></TR></TBODY></TABLE><P></P><P>I need the same data in below format:</P><P></P><TABLE><TBODY><TR><TD>Invoice No.</TD><TD>Scheme Code1</TD><TD>Scheme Code2</TD></TR><TR><TD>121</TD><TD>A01</TD><TD>A02</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks in advance</P></BODY></HTML> Mon, 03 Aug 2015 06:48:01 GMT https://community.qlik.com/t5/QlikView/Splitting-Multiple-entries-into-different-columns/m-p/907581#M652313 alkesh_sharma 2015-08-03T06:48:01Z Re: Splitting Multiple entries into different columns https://community.qlik.com/t5/QlikView/Splitting-Multiple-entries-into-different-columns/m-p/907582#M652314 <HTML><HEAD></HEAD><BODY><P>Have a look on the attachment. Hope it will solve your problem.</P></BODY></HTML> Mon, 03 Aug 2015 06:58:04 GMT https://community.qlik.com/t5/QlikView/Splitting-Multiple-entries-into-different-columns/m-p/907582#M652314 senpradip007 2015-08-03T06:58:04Z Re: Splitting Multiple entries into different columns https://community.qlik.com/t5/QlikView/Splitting-Multiple-entries-into-different-columns/m-p/907583#M652315 <HTML><HEAD></HEAD><BODY><P>Thanks Sir, this will do the trick...:)</P></BODY></HTML> Mon, 03 Aug 2015 07:08:08 GMT https://community.qlik.com/t5/QlikView/Splitting-Multiple-entries-into-different-columns/m-p/907583#M652315 alkesh_sharma 2015-08-03T07:08:08Z Re: Splitting Multiple entries into different columns https://community.qlik.com/t5/QlikView/Splitting-Multiple-entries-into-different-columns/m-p/907584#M652316 <HTML><HEAD></HEAD><BODY><P>welcome!!!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/cool.png" /></P></BODY></HTML> Mon, 03 Aug 2015 07:12:07 GMT https://community.qlik.com/t5/QlikView/Splitting-Multiple-entries-into-different-columns/m-p/907584#M652316 senpradip007 2015-08-03T07:12:07Z