Rename a Column from "A" to "DepartmentName"

[sjay1234]

I need to change my column names so that they are changed from "A", "B", "C" etc to "DepartmentName", "Email", "Phone"..

i have seen a youtube video but when i follow this, it does NOT work in Excel 2019.

Can anyone help as i need to do this and "Protect" the column names so that they cannot be changed.

thanks in advance!

Regards,
Samantha Kidd

 

[sandy666]

or if you don't want a helper table (Table2) in the sheet you can use Table.FromRecords in new Query:

// TFR
Table.FromRecords({[A = "Department", B = "Email", C = "Phone"]})

then

let
    Source = Table.Combine({TFR, Table1}),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
    #"Promoted Headers"