cross table for many fields

[RimDataAnalyst]

Hello ,
I am working on a google sheet file of alerts status date  for every ID_alerts  where there is data entered in columns that I want to pivot them online.
here is the file :

I want to convert the rows from Backlog to Ready for deployment for every ID_alerts   that is to say for each ID_alerts I add as many statuses as filled in
here is the data load script:

Scoping_Integration:

LOAD [Alert ID (FaultCode) - Alert Version - AC Type (Program Line) - Conf - ATA 6D - AC SubType - AC Engine Type - Alert Name] as [GetSheetValues.Alert ID (FaultCode) - Alert Version - AC Type (Program Line) - Conf - ATA 6D - AC SubType - AC Engine Type - Alert Name],
[Alert ID (FaultCode) - Alert Version] as [GetSheetValues.Alert ID (FaultCode) - Alert Version],
[ATA 2D] as [GetSheetValues.ATA 2D],
[ATA 6D] as [GetSheetValues.ATA 6D],
Conf as [GetSheetValues.Conf],
[AC Type] as [GetSheetValues.AC Type],
[Program Line] as [GetSheetValues.Program Line],
[AC SubType] as [Scoping_Integration.AC SubType],
[AC Engine Type] as [GetSheetValues.AC Engine Type],
Partner as [GetSheetValues.Partner],
Product as [GetSheetValues.Product],
Backlog as [GetSheetValues.Backlog],
Scope as [GetSheetValues.Scope],
[Planned Delivery date] as [GetSheetValues.Planned Delivery date],
"[Dev] Alert Data Mgt" as [GetSheetValues.[Dev]] Alert Data Mgt],
"[Dev] Under development" as [GetSheetValues.[Dev]] Under development],
"[Integration] Technical" as [GetSheetValues.[Integration]] Technical],
"[Integration] Functional" as [GetSheetValues.[Integration]] Functional],
[Ready for exposure] as [GetSheetValues.Ready for exposure],
"[Validation] Ops & Perfo Assessment" as [GetSheetValues.[Validation]] Ops & Perfo Assessment],
[Ready for Deployment] as [GetSheetValues.Ready for Deployment],
Active as [GetSheetValues.Active],
Passive as [GetSheetValues.Passive],
Exit as [GetSheetValues.Exit];

SELECT [Alert ID (FaultCode) - Alert Version - AC Type (Program Line) - Conf - ATA 6D - AC SubType - AC Engine Type - Alert Name],
[Alert ID (FaultCode) - Alert Version],
[ATA 2D],
[ATA 6D],
Conf,
[AC Type],
[Program Line],
[AC SubType],
[AC Engine Type],
Partner,
Product,
Backlog,
Scope,
[Planned Delivery date],
"[Dev] Alert Data Mgt",
"[Dev] Under development",
"[Integration] Technical",
"[Integration] Functional",
[Ready for exposure],
"[Validation] Ops & Perfo Assessment",
[Ready for Deployment],
Active,
Passive,
Exit
FROM GetSheetValues
WITH PROPERTIES (
spreadsheetKey='1ThWGbQC3ccRhzi_w7fXA0BIx8HkWsk8cY3hJt3GIGMU',
range='Scoping-Integration!A1:X',
valueRenderOption='FORMATTED_VALUE',
dateTimeRenderOption='FORMATTED_STRING',
generatedNumberedColumns='false',
skipRows=''
);

i know i want to add the crosstable function but i don't know how exactly
Thank you for your help