Cross Table or something else?

[bazzaonline]

Hello,

Im trying to load an excel spreadsheet with data but need to transpose some of columns so I get a really simple table in qlik, is this possible?

Excel Input
Field 1	Field 2	Field 3	Jan	Feb	Mar	Apr
a	d	g	1	2	5	1
b	e	h	7	3	2	4
c	f	i	4	8	2	4
Qlik Table
Field 1
Field 2
Field 3
Months

Thanks in advance

[Vegar · Accepted solution]

Try using Crosstable()

CrossTable(Month, Value,3)
LOAD * Inline [
Field 1,Field 2,Field 3,Jan,Feb,Mar,Apr	 
a, d, g, 1, 2, 5, 1
b, e, h, 7, 3, 2, 4
c, f, i, 4, 8, 2, 4]
;

[bazzaonline]

Briiliant, really helpful.  Is there anyway I can change the month field as its pulling through as a numberic field?

[Vegar]

I'm sorry, but I don't really understand your issue. Could you try to post a picture or explain again in other words?