Excel source - Transpose only a few columns

[#1]

Hi ,

I have a Excel Tab (data source):

ColA , ColB , ColC , ColD , ColE , ColF , ColG , ... ColZ

Ligne 1 InfoA1 InfoB1 , InfoC1 , InfoD1, InfoE1 , ValueF1 , ValueG1 , ... , ValueZ1

Ligne 2 InfoA2 InfoB2 , InfoC2 , InfoD2 , InfoE2 , ValueF2 , ValueG2 , ... , ValueZ2

Ligne 3 ....

And i want my data like this to used in Qlikview :

ColA , ColB , ColC , ColD , ColE , ColF , ColG

Ligne 1 F InfoA1 InfoB1 , InfoC1 , InfoD1, InfoE1 , NameofColF, ValueF1 ,

Ligne 1 G InfoA1 InfoB1 , InfoC1 , InfoD1, InfoE1 , NameofColG, ValueG1 ,

Ligne 1 ... InfoA1 InfoB1 , InfoC1 , InfoD1, InfoE1 , NameofColn, Valuen1 ,

Ligne 1 Z InfoA1 InfoB1 , InfoC1 , InfoD1, InfoE1 , NameofColZ, ValueZ1 ,

Ligne 2 F InfoA2 InfoB2 , InfoC2, InfoD2, InfoE2 , NameofColF, ValueF2 ,

Ligne 2 G InfoA2 InfoB2 , InfoC2, InfoD2, InfoEé , NameofColG, ValueG2 ,

Ligne 2 ... InfoA2 InfoB2 , InfoC2 , InfoD2, InfoE2 , NameofColn, Valuen2 ,

Ligne 2 Z InfoA2 InfoB2 , InfoC2 , InfoD2, InfoE2 , NameofColZ, ValueZ2 ,

....

I m novice an Qlikview, I tried to use transpose but no succes because all the Excel tab is transposed ...

Have you an idea ?

[#2 · Accepted solution]

I m sorry , i found solution , it s a "CrossTab" , Lesson 20 from Tutorial