Forum Discussion
Mic1979
Post Partisan
Post PartisanCells Offset
Dear all, I need to shift the cells on the right in my workload. The idea is this: 1. I need to check what stored is in the column "Name". 2. If in the cells of the column "Name" I have the...
OffsetLabour = ((cols) => Table.SplitColumn( Table.CombineColumns( #"Changed Type1", cols, (x) => if Text.Contains(x{0}, "Labour") then {x{0}, x{2}, x{1}} else x, "combined" ), "combined", (x) => x, cols ))({"Name", "Part Number", "Labour Cost (MATURE)"})
AlienSx
Super User
Super User OffsetLabour = ((cols) => Table.SplitColumn(
Table.CombineColumns(
#"Changed Type1",
cols,
(x) => if Text.Contains(x{0}, "Labour") then {x{0}, x{2}, x{1}} else x,
"combined"
),
"combined",
(x) => x,
cols
))({"Name", "Part Number", "Labour Cost (MATURE)"})