Loading Table Column Types from Another Table

With non-primitive type support:

let
    // TextToType function
    #"Type Table" = Table.FromRows({
                            {"text", Text.Type},
                            {"Integer", Int64.Type},
                            {"Floating Point", Number.Type}
                        },
                        Type.AddTableKey (type table [#"Json Type" = text, #"Actual Type" = type] , {"Json Type"}, true) ),
    TextToType = (jsontype as any) as type => #"Type Table"{[#"Json Type" = jsontype]}[Actual Type],

    // First table
    FirstTable = Table.FromRecords({
        [name = "George", age = 22, score=50],
        [name = "Sarah", age = 19, score=201]
    }),

    // Second Table
    SecondTable = Table.FromRecords({
        [name = "text", age = "Integer", score="Floating Point"]
    }),
    #"Add Types to Second Table" = Table.TransformColumns(Table.Transpose(Table.DemoteHeaders(SecondTable)), {{"Column2", TextToType, type type}}),
    TypeList = List.Zip ({#"Add Types to Second Table"[Column1], #"Add Types to Second Table"[Column2]}),

    // Transform Types
    #"Types to first table" = Table.TransformColumnTypes(FirstTable, TypeList)
in
    #"Types to first table"

So basically if you ever get more than these three types, you'll  just need to add them in the #"Type Table"