transformation of rows into column

[#1]

hi all i want transform my table in excel file

the table is like this

as follows

Header 1	Header 2	Header 3	Header 4	Header 5	Header 6
EMP id	2008	2009	2010	2011	2012
100011100	5	3	4	3	2
10011101	4	5	2	4	5

i have 100 employee

i want transform it into  as follows by using qlikview

Header 1	Header 2	Header 3
empid	year	rating
100011100	2008	5
100011101	2008	4
100011102	2008	3
an so on as follows
100011100	2009	3
100011101	2009	5

am attaching excel files 

[Sokkorn · Accepted solution]

Hi,

CrossTable can do this job. Let try this script:

[Data]:

CrossTable(Years, Rate,1)

LOAD [Employee Id],

    [2012],

    [2011],

    [2010],

    [2009],

    [2008]

FROM E_Rating_old.xlsx

(ooxml, embedded labels, table is Sheet1);

See sample attached file.

Regards,

Sokkorn

[#3]

You can use crosstable () in your script on year & Rating

Might be something like :

Rating:

Crosstable (Year, Raing,1)

Load [Employee Id],

2008,

2009,

......

From (Your source excel);

Once done, you can create a table box listing all the 3 fields i.e. Employee Id, Year, Rating which will give you the desired result.

Hope this helps!

[#4]

yes exactly

please tell me how to do that step by step i tried can't completed 

[Sokkorn]

Hi,

Follow this: