Forum Discussion
Combine 2 columns to one column by adding rows
Hello there, I have a set of data as below in a pivot form from the 4th columns. The first row is read as Supplier AG produce Product Line of Footwear with total component weight of 300 kg. The...
NewStep=#table({"Supplier","Product Line","Component","Component %","Weight (kg)"},List.TransformMany(Table.ToRows(PreviousStepName),each List.Select(List.Split(List.Skip(_,3),3),each Text.From(_{0}??"")<>""),(x,y)=>List.FirstN(x,2)&y))
NewStep=#table({"Supplier","Product Line","Component","Component %","Weight (kg)"},List.TransformMany(Table.ToRows(PreviousStepName),each List.Select(List.Split(List.Skip(_,3),3),each Text.From(_{0}??"")<>""),(x,y)=>List.FirstN(x,2)&y))