topic Crosstable Problem in QlikView https://community.qlik.com/t5/QlikView/Crosstable-Problem/m-p/200455#M58968 <HTML><HEAD></HEAD><BODY><P>Hi *,</P><P></P><P>I have a excel table that looks like this</P><P>Salescategory I Salescategory II Salescategory III<BR />Customer|Name| 2005|2006|2007 2005|2006|2007 2005|2006|2007<BR /><BR /><BR />Normally I would use crosstable to load the data. My Problem is that I alos need the "Salescategory information."<BR />Is there a way to transform the excel file in QV?<BR />Thanks for your help.</P><P>Regards</P><P>Aloah</P></BODY></HTML> Thu, 01 Apr 2010 13:34:51 GMT 2010-04-01T13:34:51Z Crosstable Problem https://community.qlik.com/t5/QlikView/Crosstable-Problem/m-p/200455#M58968 <HTML><HEAD></HEAD><BODY><P>Hi *,</P><P></P><P>I have a excel table that looks like this</P><P>Salescategory I Salescategory II Salescategory III<BR />Customer|Name| 2005|2006|2007 2005|2006|2007 2005|2006|2007<BR /><BR /><BR />Normally I would use crosstable to load the data. My Problem is that I alos need the "Salescategory information."<BR />Is there a way to transform the excel file in QV?<BR />Thanks for your help.</P><P>Regards</P><P>Aloah</P></BODY></HTML> Thu, 01 Apr 2010 13:34:51 GMT https://community.qlik.com/t5/QlikView/Crosstable-Problem/m-p/200455#M58968 2010-04-01T13:34:51Z Crosstable Problem https://community.qlik.com/t5/QlikView/Crosstable-Problem/m-p/200456#M58969 <HTML><HEAD></HEAD><BODY><P>Is it possible to merge cells during load? in this case merge row 1&amp;2, do a crosstable load and split them afterwards again?</P></BODY></HTML> Thu, 01 Apr 2010 14:43:39 GMT https://community.qlik.com/t5/QlikView/Crosstable-Problem/m-p/200456#M58969 2010-04-01T14:43:39Z