let
    Source = Excel.Workbook(Web.Contents("https://someSPOLsite.com/Employee%20Workflow%20Steps.xlsx"), null, true),
    #"Employee Workflow Steps_Sheet" = Source{[Item="Employee Workflow Steps",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(#"Employee Workflow Steps_Sheet", [PromoteAllScalars=true]),
    #"Added Custom" = Table.AddColumn(#"Promoted Headers", "PBIStuff", each 0),
    #"Changed Type" = Table.TransformColumnTypes(#"Added Custom",{{"Business Organization Name", type text}, {"Employee Last Name", type text}, {"Employee First Name", type text}, {"Employee Middle Name", type text}, {"Employee Code", type text}, {"Employee Email", type text}, {"Employee Id", type text}, {"Workflow Definition Name", type text}, {"Step Definition Name", type text}, {"Workflow Created Date", type datetime}, {"Workflow Completed Date", type any}, {"Step Start Date", type datetime}, {"Step Completed Date", type datetime}, {"Step Completed By First Name", type text}, {"Step Completed By Last Name", type text}, {"Step Completed By Name", type text}, {"Step Action Name", type text}, {"Step Created By First Name", type text}, {"Step Created By Last Name", type text}, {"Step Created By Name", type text}, {"Step Created Date", type datetime}, {"Workflow State", type text}, {"Workflow Active Steps", type text}, {"Workflow Current Assignees", type text}, {"GLC Code", type text}, {"GLC Description", type text}, {"PLC Code", type any}, {"PLC Description", type any}, {"Position Job Number", type text}, {"Position Job Name", type text}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Employee Last Name", "Candidate Last Name"}, {"Employee First Name", "Candidate First Name"}, {"Employee Middle Name", "Candidate Middle Name"}, {"Employee Code", "Candidate Code"}, {"Employee Email", "Candidate Email"}, {"Employee Id", "Candidate ID"}, {"Workflow Definition Name", "Process Type"}, {"Step Definition Name", "Process Name"}, {"Workflow Created Date", "Process Start Date"}, {"Workflow Completed Date", "Process Completed Date"}, {"Step Start Date", "Process Step Start Date"}, {"Step Completed Date", "Process Step Completed Date"}, {"Step Completed By First Name", "Process Step Completed By First Name"}, {"Step Completed By Last Name", "Process Step Completed By Last Name"}, {"Step Completed By Name", "Process Step Completed By ID"}, {"Step Action Name", "Process Action Name"}, {"Step Created By First Name", "Action Step Created By First Name"}, {"Step Created By Last Name", "Action Step Created By Last Name"}, {"Step Created By Name", "Action Created By ID"}, {"Step Created Date", "Action Created Date"}, {"Workflow State", "Action Status"}, {"Workflow Active Steps", "Current Action"}, {"Workflow Current Assignees", "Process Current Assignees ID"}}),
    #"Grouped Rows" = Table.Group(#"Renamed Columns", {"Business Organization Name"}, {{"AllRows", each _, type table [Business Organization Name=nullable text, Candidate Last Name=nullable text, Candidate First Name=nullable text, Candidate Middle Name=nullable text, Candidate Code=nullable text, Candidate Email=nullable text, Candidate ID=nullable text, Process Type=nullable text, Process Name=nullable text, Process Start Date=nullable datetime, Process Completed Date=any, Process Step Start Date=nullable datetime, Process Step Completed Date=nullable datetime, Process Step Completed By First Name=nullable text, Process Step Completed By Last Name=nullable text, Process Step Completed By ID=nullable text, Process Action Name=nullable text, Action Step Created By First Name=nullable text, Action Step Created By Last Name=nullable text, Action Created By ID=nullable text, Action Created Date=nullable datetime, Action Status=nullable text, Current Action=nullable text, Process Current Assignees ID=nullable text, GLC Code=nullable text, GLC Description=nullable text, PLC Code=any, PLC Description=any, Position Job Number=nullable text, Position Job Name=nullable text]}})
in
    #"Grouped Rows"