set column data type firxt X and remaining

[JackDanIce]

Hi,

Is there a way to use Table.TransformColumnTypes where instead of listing each column field value, I can have the first 11 columns as type text and the remaining columns as type number?

Below errors

let
    Source = Table.Transpose(Excel.CurrentWorkbook(){[Name="Output_Column_Fields"]}[Content]),
    promote_headers = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    
    col_names = Table.ColumnNames(promote_headers),
    first_11 = List.FirstN(col_names, 11),
    remainder = List.RemoveFirstN(col_names, 11),
    change_type = Table.TransformColumnTypes(promote_headers,List.Combine({first_11, remainder})),

 

[Bo_Ry]

Please try

    col_type = List.Repeat({type text},11) & List.Repeat({type number}, List.Count(col_names)-11),
    change_type = Table.TransformColumnTypes(Source, List.Zip({col_names,col_type }))

 

[JackDanIce]

Oh nice, I like it! Thank you very much @Bo_Ry