Multiple columns in to one column and Join

[amithmurali]

Hi guys, i am having trouble with this data,

Units	Dept wise Patient count	Jan			Feb
	2014	2015	2015	2014	2015	2015
		Actual	Budget	Actual	Actual	Budget	Actual
CCJ	ALLERGY CLINIC	0	0	0	0	0	0
PVT	ALLERGY CLINIC	0	0	0	0	0	0
MDCLG	ALLERGY CLINIC	153	153	122	151	151	154

My table is like this. how to work on it to get fields like this "jan 2014 actual" , "jan 2015 Actual , "jan 2015 Budget".

[robert_mika]

Does this help?

LOAD Units,

     F2 as Year,

     F3 as Category,

     CCJ,

     PVT,

     MDCLG

FROM

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

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

Replace(8, left, StrCnd(null)),

Transpose(),

Remove(Row, Pos(Top, 2))

));