Inverse function of Crosstable

[isabelaadelina_]

Hi, a have a table like this one: 

I want the highlighted field named "measure"  to be split in different columns with them respective values( secondo field highlighted: so I will have the column named Units with the value 9, 25, 40, 22. Like an inverse function of Cross Table. Can I do it in Qlik Sense?

Thank You!

[Saravanan_Desingh]

Are you looking something like this?

tab1:
LOAD * INLINE [
    ISO, Brand, measure, Date, Value
    32, ABC, Units, 1/1/2018, 9
    32, ABC, Units, 2/1/2018, 25
    32, ABC, Units, 3/1/2018, 40
    32, ABC, Units, 4/1/2018, 22
    32, ABC, Units, 5/1/2018, 3
    32, ABC, Units, 6/1/2018, 6
    32, ABC, Units, 7/1/2018, 9
    32, ABC, Units, 8/1/2018, 40
    32, ABC, Units, 9/1/2018, 9
];

Gen:
Generic
LOAD ISO, Brand, Date, measure&'_'&Value,'X'
Resident tab1;

Drop Table tab1;

[Vegar]

@isabelaadelina_ 

Using generic load can solve your issue as @Saravanan_Desingh wrote in the previous answer. I recommend developers to read this post, The Generic Load by @hic ,  when introduced to the Generic function. 

[Saravanan_Desingh]

Did you look into the above solution provided?