How to make Straight Table into Crosstable table in Qliksense script

[Jeff2022]

Dears

I had met a question from straight table into cross table in Qliksense script.

1,table1:straight table

CustomerNo	Period	Catergory	Value
A	2022-01	out_of_warranty	10
B	2022-01	out_of_mc	20
C	2022-01	out_of_warranty	10
D	2022-01	out_of_mc	20
A	2022-01	out_of_warranty	10
B	2022-01	out_of_mc	20
C	2022-01	out_of_warranty	10
D	2022-01	out_of_mc	20

2,table2:crosstable 

CustomerNo	Period	out_of_warranty	out_of_mc
A	2022-01	1	1
B	2022-01	1	2
C	2022-01	2	2
D	2022-01	1	1
A	2022-01	1	1
B	2022-01	1	1
C	2022-01	1	1
D	2022-01	1	0

who can help? Thank you so much.