How to convert column data to row data

[krishna14]

Hi,

I want how to convert column data to rowdata in qlikview

Ex:  Name    Maths     English  

       kris           99           78

        Raja        90              66.

above example

  I need convert to column to row like tat

Name        kris    Raja

Maths         99     90

English       78       66.

[srinu1331]

Using through CrossTable Concept

[qlik4asif]

While loading file Select Enable Transformation step button

Go to rotate tab

Use Left and Transpose buttons

You can see preview there

And then load file

[qlik4asif · Accepted solution]

Code will generate like this

Directory;

LOAD Name,

     Kris,

     Raja

FROM

Book2.xlsx

(ooxml, embedded labels, table is Sheet1, filters(

Rotate(left),

Transpose(),

Rotate(left)

));

[qlik4asif]

Hope i have answered ur question:)

[sahadevpatil140]

Hi,

Browse input data

click on Enable Transformation step -> Rotate -> Transpose

Regards

Sahadev