Table

[#1]

Hello,

How can I change a table as tab1 to tab2?

Thank you very much!

tab1:

Header1	Header 2	Header 3
A	B	C

tab2:

Name	Number
Header1	A
Header2	B
Header3	C

[#2]

Use the Cross table function in your loading script.

Watch this video it explain how it can be done : Loading Cross Tables

[MK_QSL]

CrossTable(Name, Number)

Load '1' as Dummy, * Inline

[

  Header1, Header2, Header3

  A, B, C

];

Drop Field Dummy;

[d_koti24 · Accepted solution]

Hi,

By Using Cross table,you can get this one.

Find the below sample qvw.

[settu_periasamy]

Hi,

if you want to transpose the data, try the below script.

Tab2:
LOAD @1 as Name,
     @2 as Number
FROM
[https://community.qlik.com/thread/169114]
(html, codepage is 1252, no labels, table is @1, filters(Transpose()));

if you have the source in excel, try the below script.

Directory;
LOAD @1 as Name, 
     @2 as Number
FROM
Book1.xlsx
(ooxml, no labels, table is Sheet1, filters(Transpose()));

[MK_QSL]