How to change row to header in Qlik sense?

[damian25]

Hi,

I have an Excel sheet like this :

Projectnumber	P00025-31	P00025-32	P00025-33
Projecttype	A	B	C
Object	Rijwoningen	Hoekwoningen	Twee-onder-één-kap
Koop/Huur	Koop	Koop	Huur
Name	Nieuwbouw	Nieuwbouw	Nieuwbouw

In Qlik i would like to have a table like this:

Projectnumber	Projecttype	Object	Koop/Huur	Name
P00025-31	A	Rijwoningen	Koop	Nieuwbouw
P00025-32	B	Hoekwoningen	Koop	Nieuwbouw
P00025-33	C	Twee-onder-één-kap	Huur	Nieuwbouw

Can someone help me with this?

[Steven_Haught]

@damian25 

You could try using Unpivot in the Data manager. Instructions on how to do this can be found here:

https://help.qlik.com/en-US/sense/September2020/Subsystems/Hub/Content/Sense_Hub/LoadData/unpivot-cr...