topic Excel source - Transpose only a few columns in QlikView https://community.qlik.com/t5/QlikView/Excel-source-Transpose-only-a-few-columns/m-p/202481#M60170 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>I have a Excel Tab (data source):</P><P>ColA , ColB , ColC , ColD , ColE , ColF , ColG , ... ColZ</P><P>Ligne 1 InfoA1 InfoB1 , InfoC1 , InfoD1, InfoE1 , ValueF1 , ValueG1 , ... , ValueZ1</P><P>Ligne 2 InfoA2 InfoB2 , InfoC2 , InfoD2 , InfoE2 , ValueF2 , ValueG2 , ... , ValueZ2</P><P>Ligne 3 ....</P><P></P><P>And i want my data like this to used in Qlikview :</P><P>ColA , ColB , ColC , ColD , ColE , ColF , ColG</P><P>Ligne 1 F InfoA1 InfoB1 , InfoC1 , InfoD1, InfoE1 , NameofColF, ValueF1 ,</P><P>Ligne 1 G InfoA1 InfoB1 , InfoC1 , InfoD1, InfoE1 , NameofColG, ValueG1 ,</P><P>Ligne 1 ... InfoA1 InfoB1 , InfoC1 , InfoD1, InfoE1 , NameofColn, Valuen1 ,</P><P>Ligne 1 Z InfoA1 InfoB1 , InfoC1 , InfoD1, InfoE1 , NameofColZ, ValueZ1 ,</P><P>Ligne 2 F InfoA2 InfoB2 , InfoC2, InfoD2, InfoE2 , NameofColF, ValueF2 ,</P><P>Ligne 2 G InfoA2 InfoB2 , InfoC2, InfoD2, InfoEé , NameofColG, ValueG2 ,</P><P>Ligne 2 ... InfoA2 InfoB2 , InfoC2 , InfoD2, InfoE2 , NameofColn, Valuen2 ,</P><P>Ligne 2 Z InfoA2 InfoB2 , InfoC2 , InfoD2, InfoE2 , NameofColZ, ValueZ2 ,</P><P>....</P><P>I m novice an Qlikview, I tried to use transpose but no succes because all the Excel tab is transposed ...</P><P>Have you an idea ?</P></BODY></HTML> Thu, 07 Apr 2011 09:50:29 GMT 2011-04-07T09:50:29Z Excel source - Transpose only a few columns https://community.qlik.com/t5/QlikView/Excel-source-Transpose-only-a-few-columns/m-p/202481#M60170 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>I have a Excel Tab (data source):</P><P>ColA , ColB , ColC , ColD , ColE , ColF , ColG , ... ColZ</P><P>Ligne 1 InfoA1 InfoB1 , InfoC1 , InfoD1, InfoE1 , ValueF1 , ValueG1 , ... , ValueZ1</P><P>Ligne 2 InfoA2 InfoB2 , InfoC2 , InfoD2 , InfoE2 , ValueF2 , ValueG2 , ... , ValueZ2</P><P>Ligne 3 ....</P><P></P><P>And i want my data like this to used in Qlikview :</P><P>ColA , ColB , ColC , ColD , ColE , ColF , ColG</P><P>Ligne 1 F InfoA1 InfoB1 , InfoC1 , InfoD1, InfoE1 , NameofColF, ValueF1 ,</P><P>Ligne 1 G InfoA1 InfoB1 , InfoC1 , InfoD1, InfoE1 , NameofColG, ValueG1 ,</P><P>Ligne 1 ... InfoA1 InfoB1 , InfoC1 , InfoD1, InfoE1 , NameofColn, Valuen1 ,</P><P>Ligne 1 Z InfoA1 InfoB1 , InfoC1 , InfoD1, InfoE1 , NameofColZ, ValueZ1 ,</P><P>Ligne 2 F InfoA2 InfoB2 , InfoC2, InfoD2, InfoE2 , NameofColF, ValueF2 ,</P><P>Ligne 2 G InfoA2 InfoB2 , InfoC2, InfoD2, InfoEé , NameofColG, ValueG2 ,</P><P>Ligne 2 ... InfoA2 InfoB2 , InfoC2 , InfoD2, InfoE2 , NameofColn, Valuen2 ,</P><P>Ligne 2 Z InfoA2 InfoB2 , InfoC2 , InfoD2, InfoE2 , NameofColZ, ValueZ2 ,</P><P>....</P><P>I m novice an Qlikview, I tried to use transpose but no succes because all the Excel tab is transposed ...</P><P>Have you an idea ?</P></BODY></HTML> Thu, 07 Apr 2011 09:50:29 GMT https://community.qlik.com/t5/QlikView/Excel-source-Transpose-only-a-few-columns/m-p/202481#M60170 2011-04-07T09:50:29Z Excel source - Transpose only a few columns https://community.qlik.com/t5/QlikView/Excel-source-Transpose-only-a-few-columns/m-p/202482#M60171 <HTML><HEAD></HEAD><BODY><P>I m sorry , i found solution , it s a "CrossTab" , Lesson 20 from Tutorial</P></BODY></HTML> Thu, 07 Apr 2011 10:54:36 GMT https://community.qlik.com/t5/QlikView/Excel-source-Transpose-only-a-few-columns/m-p/202482#M60171 2011-04-07T10:54:36Z