Rows into columns

[pavanqlik]

Hi Friends,

I had a scenario where i need to make rows into columns in qlikview.

For Ex:

   My source .xlsx has below data

    company name    account number 1    account number 2      account number 3

     ABC                              1                              2                               3

     CDE                               8                                                              10

My output should be:

company name               account number

ABC                                     1

ABC                                     2

ABC                                     3

CDE                                     8

CDE                                    10

Could you please help me on above.

Thanks,

Pavan

[Anonymous]

Sounds like you need the CrossTable() function which is explained in the Blog Post.

The Crosstable Load

[MayilVahanan]

HI

Try like

crosstable(AccountName, AccountNumber, 1)

Load * from yourtablename;

[sunny_talwar]

Have you looked at CrossTable() Load? Check it out: The Crosstable Load

[ajayrai]

CrossTable([Acc 1], [Account No.])
LOAD Company,
[Acc 1],
[Acc 2],
[Acc 3]
FROM

(ooxml, embedded labels, table is Sheet2);

use this script for cross table or do the below steps while loading table

[avinashelite]

use crosstable function ;

The Crosstable Load