I have created a Custom Function in Power Query to return online data for multiple years in Excel.

Unfortunately, in different years they changed the text case of some (but not all) of the column headers, thereby giving be a "null" value when there should be data. Any idea how to change. See sample below. The "Expanded Column1" step is the problem, as I can see data in the "converted to table" section. I have tried using Comparer.OrdinalIgnoreCase operator, but it did not work. Any ideas? Thanks.

 let
    Source = Json.Document(Web.Contents(XXXXX)),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"PROVNUM", "PROVNAME", "CITY", "STATE", "COUNTY_NAME", "COUNTY_FIPS", "CY_Qtr", "WorkDate", "MDScensus", "Hrs_Admin", "Hrs_Admin_emp", "Hrs_Admin_ctr", "Hrs_MedDir", "Hrs_MedDir_emp", "Hrs_MedDir_ctr", "Hrs_OthMD", "Hrs_OthMD_emp", "Hrs_OthMD_ctr", "Hrs_PA", "Hrs_PA_emp", "Hrs_PA_ctr", "Hrs_NP", "Hrs_NP_emp", "Hrs_NP_ctr", "Hrs_ClinNrsSpec", "Hrs_ClinNrsSpec_emp", "Hrs_ClinNrsSpec_ctr", "Hrs_Pharmacist", "Hrs_Pharmacist_emp", "Hrs_Pharmacist_ctr", "Hrs_Dietician", "Hrs_Dietician_emp", "Hrs_Dietician_ctr", "Hrs_FeedAsst", "Hrs_FeedAsst_emp", "Hrs_FeedAsst_ctr", "Hrs_OT", "Hrs_OT_emp", "Hrs_OT_ctr", "Hrs_OTasst", "Hrs_OTasst_emp", "Hrs_OTasst_ctr", "Hrs_OTaide", "Hrs_OTaide_emp", "Hrs_OTaide_ctr", "Hrs_PT", "Hrs_PT_emp", "Hrs_PT_ctr", "Hrs_PTasst", "Hrs_PTasst_emp", "Hrs_PTasst_ctr", "Hrs_PTaide", "Hrs_PTaide_emp", "Hrs_PTaide_ctr", "Hrs_RespTher", "Hrs_RespTher_emp", "Hrs_RespTher_ctr", "Hrs_RespTech", "Hrs_RespTech_emp", "Hrs_RespTech_ctr", "Hrs_SpcLangPath", "Hrs_SpcLangPath_emp", "Hrs_SpcLangPath_ctr", "Hrs_TherRecSpec", "Hrs_TherRecSpec_emp", "Hrs_TherRecSpec_ctr", "Hrs_QualActvProf", "Hrs_QualActvProf_emp", "Hrs_QualActvProf_ctr", "Hrs_OthActv", "Hrs_OthActv_emp", "Hrs_OthActv_ctr", "Hrs_QualSocWrk", "Hrs_QualSocWrk_emp", "Hrs_QualSocWrk_ctr", "Hrs_OthSocWrk", "Hrs_OthSocWrk_emp", "Hrs_OthSocWrk_ctr", "Hrs_MHSvc", "Hrs_MHSvc_emp", "Hrs_MHSvc_ctr", "incomplete"}, {"PROVNUM", "PROVNAME", "CITY", "STATE", "COUNTY_NAME", "COUNTY_FIPS", "CY_Qtr", "WorkDate", "MDScensus", "Hrs_Admin", "Hrs_Admin_emp", "Hrs_Admin_ctr", "Hrs_MedDir", "Hrs_MedDir_emp", "Hrs_MedDir_ctr", "Hrs_OthMD", "Hrs_OthMD_emp", "Hrs_OthMD_ctr", "Hrs_PA", "Hrs_PA_emp", "Hrs_PA_ctr", "Hrs_NP", "Hrs_NP_emp", "Hrs_NP_ctr", "Hrs_ClinNrsSpec", "Hrs_ClinNrsSpec_emp", "Hrs_ClinNrsSpec_ctr", "Hrs_Pharmacist", "Hrs_Pharmacist_emp", "Hrs_Pharmacist_ctr", "Hrs_Dietician", "Hrs_Dietician_emp", "Hrs_Dietician_ctr", "Hrs_FeedAsst", "Hrs_FeedAsst_emp", "Hrs_FeedAsst_ctr", "Hrs_OT", "Hrs_OT_emp", "Hrs_OT_ctr", "Hrs_OTasst", "Hrs_OTasst_emp", "Hrs_OTasst_ctr", "Hrs_OTaide", "Hrs_OTaide_emp", "Hrs_OTaide_ctr", "Hrs_PT", "Hrs_PT_emp", "Hrs_PT_ctr", "Hrs_PTasst", "Hrs_PTasst_emp", "Hrs_PTasst_ctr", "Hrs_PTaide", "Hrs_PTaide_emp", "Hrs_PTaide_ctr", "Hrs_RespTher", "Hrs_RespTher_emp", "Hrs_RespTher_ctr", "Hrs_RespTech", "Hrs_RespTech_emp", "Hrs_RespTech_ctr", "Hrs_SpcLangPath", "Hrs_SpcLangPath_emp", "Hrs_SpcLangPath_ctr", "Hrs_TherRecSpec", "Hrs_TherRecSpec_emp", "Hrs_TherRecSpec_ctr", "Hrs_QualActvProf", "Hrs_QualActvProf_emp", "Hrs_QualActvProf_ctr", "Hrs_OthActv", "Hrs_OthActv_emp", "Hrs_OthActv_ctr", "Hrs_QualSocWrk", "Hrs_QualSocWrk_emp", "Hrs_QualSocWrk_ctr", "Hrs_OthSocWrk", "Hrs_OthSocWrk_emp", "Hrs_OthSocWrk_ctr", "Hrs_MHSvc", "Hrs_MHSvc_emp", "Hrs_MHSvc_ctr", "incomplete"})
in
    #"Expanded Column1"