Change column headers to columns data

[Anonymous]

Hi How do i change my data to as such

Country|Year|GDP

Peru|2014|xxx

Peru|2015|xxx

It is currently like this:

[olivierrobin]

hello

you can try to use crosstable()

see "Working with cross tables" in qlik documentation

[olivierrobin]

for example :

t:

load * inline [

country,2014,2015,2016

a,4,5,6

b,7,8,9

];

t2:

CrossTable(year,sales,1) load * resident t;

drop table t;

[MK9885]

Maybe

crosstable (Tables, GDP,5)

Load

[Country Name],

2014,

2015,

2016,

2017,

2014 as [Year 2014],

2015 as [Year 2014],

2016 as [Year 2014],

2017 as [Year 2014]

From....