let
    Source = Table.FromRecords({
        [Name = "Bob", Phone = "0812345678"],
        [Name = "Jim", Phone = "0823456789"]
    }),
    Duplicated = Table.DuplicateColumn(Source, "Phone", "Phone Copy")
in
    Duplicated

let
    Source = Table.FromRecords({
        [ID = 1, Amount = 1000],
        [ID = 2, Amount = 2000]
    }),
    WithBackup = Table.DuplicateColumn(Source, "Amount", "Original Amount"),
    Modified = Table.TransformColumns(WithBackup, {{"Amount", each _ * 1.07}})
in
    Modified

let
    Source = Table.FromRecords({
        [CustomerID = 1, Score = "85"],
        [CustomerID = 2, Score = "92"]
    }),
    Duplicated = Table.DuplicateColumn(Source, "Score", "Score Number", type number)
in
    Duplicated