let
    Source = Excel.Workbook(File.Contents("C:\Users\devanshi\OneDrive\Documents\Analytics\Power BI\Superstore Dataset.xls"), null, true),
    People1 = Source{[Name="People"]}[Data],
    #"Changed Type" = Table.TransformColumnTypes(People1,{{"Column1", type text}, {"Column2", type text}}),
    #"Promoted Headers" = Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true]),
    #"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"Person", type text}, {"Region", type text}})
in
    #"Changed Type1"