let
    Sales = Table.FromRecords({
        [OrderID = 1, Amount = 1500],
        [OrderID = 2, Amount = 2300],
        [OrderID = 3, Amount = 800]
    }),
    AmountList = Table.TransformRows(Sales, each [Amount])
in
    AmountList
// Result: {1500, 2300, 800}

let
    Invoice = Table.FromRecords({
        [Qty = 5, Price = 100],
        [Qty = 3, Price = 200],
        [Qty = 10, Price = 50]
    }),
    Totals = Table.TransformRows(Invoice, each [Qty] * [Price])
in
    Totals
// Result: {500, 600, 500}

let
    Employee = Table.FromRecords({
        [ID = 1, Name = "Alice", Salary = 50000],
        [ID = 2, Name = "Bob", Salary = 55000]
    }),
    WithBonus = Table.TransformRows(
        Employee,
        (row) => [
            ID = row[ID],
            Name = row[Name],
            Annual = row[Salary] * 12,
            Bonus = Number.ToText(row[Salary] * 0.1)
        ]
    )
in
    WithBonus
// Result: {[ID = 1, Name = "Alice", Annual = 600000, Bonus = "5000"], [ID = 2, Name = "Bob", Annual = 660000, Bonus = "5500"]}

let
    Products = Table.FromRecords({
        [ProductName = "Laptop", Category = "Electronics"],
        [ProductName = "Mouse", Category = "Electronics"],
        [ProductName = "Desk", Category = "Furniture"]
    }),
    Labels = Table.TransformRows(
        Products,
        each [Category] & ": " & [ProductName]
    )
in
    Labels
// Result: {"Electronics: Laptop", "Electronics: Mouse", "Furniture: Desk"}