excel problem

[#1]

hiii, i am uploading an excel sheet in which there is one column as group and another as material. A group has  more than one material in horizantal column.Is there is any code in qlikview to transform horizantal materials into vertical .

[#2]

May be like this?

Regards,

Kiran.

[#3]

You can try with what Kiran has suggested for...