Convert column values to rows based on another column

[martin_hamilton]

Hi

I have the following data loading via script:

Role	Apr-19	May-19	Jun-19
Analytics Engineer	0.19		0.14
Analytics Engineer		0.95
Analytics Engineer	0.33

I would like to make the column headers values within a column and retain the values against these thus creating the following table to use in charts:

Role	Month	Amount
Analytics Engineer	Apr-19	0.19
Analytics Engineer	May-19	0.95
Analytics Engineer	Jun-19	0.14

How would I do this in a script?

Thanks

Martin

[Gysbert_Wassenaar · Accepted solution]

You can use the CrossTable prefix to transform the data:

CrossTable(Month, Amount)
LOAD * FROM ....source.....

[valnod_90]

https://www.youtube.com/watch?v=xkBFyNys1LI

hope this could help you!

[martin_hamilton]

Many Thanks exactly what I was looking for.

[amulya22]

Hi,

I also have very similiar query. 

I have my data like this 

Skill                                           %Complete                   EMP ID

AI                                                  0 %                                      1

Programming                          50  %                                  2

Excel                                           100   %                              3

and this my desired table

AI                      Programming                       Excel                     EMP ID

0                            10%                                          20%                              1

30%                      40%                                        50%                                2

any help is much appreciated 

Im very new to qlik