convert rows into colomns

[#1]

I have table like

table1  this is field name

d1

d2    this are sub fields

d3

I want to get it like

table d1 d2 d3

implementation done in scripting side not in ui side.

plz help me.

[buzzy996 · Accepted solution]

crosstable

this table is converted from crosstable format to column format.

[stigchel]

That sounds like you need a generic load, see below link for an explanation:

Use cases for Generic Load | Qlikview Cookbook

[robert_mika]

Data

Transformation:

To:

Script:

Directory;

CrossTable(A, Data)

LOAD Tab1,

     A,

     B,

     C

FROM

CROSSTA.xlsx

(ooxml, embedded labels, table is Sheet1);