crosstable help

[arusanah]

I have a sheet where I need to change column2-6  to rows .  and column 1 as column header for all 5 columns.

attached is sample data file. can somebody help writing cross table () . pls

Recipient Identifier	11111	11111	11111	11111	11111
Record Identifier	10001	10002	10003	10004	10005
Month	January	February	March	April	May	<-----	actual data
Year	2016	2016	2016	2016	2016
Citizenship Code (CDE_CITSHP)	1	1	1	1	1
NAM_CITSHP	US citizen	US citizen	US citizen	US citizen	US citizen

Recipient Identifier	Record Identifier	Month	Year	Citizenship Code (CDE_CITSHP)	NAM_CITSHP
11111	10001	January	2016	1	US citizen
11111	10002	February	2016	1	US citizen
11111	10003	March	2016	1	US citizen	<-------	output
11111	10004	April	2016	1	US citizen
11111	10005	May	2016	1	US citizen

[sunny_talwar]

I don't see anything attached.

[arusanah]

somehow not letting me edit my query. I have attached a screen shorty of data

[sunny_talwar]

What is the output you are expecting to see?

[arusanah]

output should be like this

personID	month	uid	pwd	year
1	9	4	aw	2013
1	6	3	sw	2013	2
1	4	7	cz	2013	2
1	1	4	tg	2013	2
1	2	77	34	2013	2

t

[arusanah]

ignore 2 's at end

[sunny_talwar · Accepted solution]

Try this:

Table:

LOAD [person ID],

    month,

    uid,

    pwd,

    year

FROM

[https://community.qlik.com/thread/219215]

(html, codepage is 1252, embedded labels, table is @1, filters(

Transpose()

));