Transpose in importing excel data

[Mahamed_Qlik]

Dear Experts,

I have below format in the excel file :

Year/Month	Category Type	January		February
Gender		Male	Female	Male	Female
2018	Category 1			2	5
	Category 2			10	12
	3 Category			45	22
	Category 4			20	10
2019	Category 1			12	55
	Category 2			77	3
	3 Category			66	2
	Category 4			44	5

And this is our expectation in the qlik sense table :

Note:  We have 4 years of the data ( 2018 to 2022) and we have 8 categories also we need to show for all the month.
             In above example it is showing only for 2 months.

Kindly help.

Regards,
Mahamed.

[Mahamed_Qlik]

Solution anyone ???

[brunobertels]

Hi

See this post 

https://community.qlik.com/t5/New-to-Qlik-Sense/Excel-load-with-Cross-Table/td-p/1694647 

both of solution are OK

regards 

[Mahamed_Qlik]

Thank you for your response, but given solution does not suits in our case.

[Mahamed_Qlik]

Awaiting for solution