Forum Discussion
Merging multiple rows into one row
Hello, I'm trying to figure out a way to pull the date field into each row. In the attached I show what the data looks like and then what I'm looking to achieve. Each record is multiple rows and...
NewStep=Table.Combine(Table.Group(PreviousStepName,"Column1",{"n",each let a=Table.FirstN(_,3),b=Table.LastN(_,1),c=Table.RemoveLastN(Table.Skip(_,3),1) in a&Table.ReplaceValue(c,"",a[Column3]{0},(x,y,z)=>z,{"Column3"})&b},0,(x,y)=>Byte.From(y="Company Name"))[n])