Forum Discussion
Patternless Data Need to Append or Combine
I am working on PDF bank statements. I've been importing each statement into Excel via Data ->Import PDF. From there, I transform the data. I'm working with tables only (not pages). At times, I've su...
NewStep= Table.FromRecords(List.Accumulate(Table.ToRecords(PreviousStepName)&{[Date=""]},{},(x,y)=>if x={} then {{},y} else if y[Date]=null then {x{0},x{1}&[DESCRIPTION=Text.Combine({x{1}[DESCRIPTION],y[DESCRIPTION]}," ")]} else {x{0}&{x{1}},y}){0})