Importing PDF with Power Query - values not alocated in correct cells

[gtanaka]

Hi!
I need help to fix the folloing problem:

Some values when I import PDF are being alocated in the wrong place, grouped in a cell, leaving an empty place where the value should be.

[AlienSx · Accepted solution]

Hello, @gtanaka try this

let
    Source = your_table,
    cols = Table.ToColumns(Source),
    first = List.Combine(List.RemoveNulls(List.Transform(cols{0}, (x) => Splitter.SplitTextByDelimiter("#(lf)")(x)))),
    res = Table.FromColumns({first} & List.Skip(cols, 1), Table.ColumnNames(Source))
in
    res

[gtanaka]

thank you!!!