Power Query Help

[Shaz_Mthembu]

Hi All

Please help, after loading my pdf statement into power query, my description spills over down to a second row and creates also a null row.

My wish is to then merge my description from null row back to row above it as one full description.

 

[JEC]

Can do but I need your sample data

 

[Shaz_Mthembu]

Can do but I need your sample data

Hi JEC

Thank you for your reply, see attached, alternatively if you do not mind, email a test email to shadrackmthembu@gmail.com and I will send sample file

 

[JEC]

Can you post the data here? In table format or use the Xl2BB tool

 

[alex78]

Hi,
Try something like this,

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    ColName = Table.ColumnNames(Source),
    #"Grouped Rows" = Table.FromRecords(Table.Group(Table.FillDown(Source, {ColName{1}}), ColName{1}, {{"Custom", each let x = Text.Combine(Table.Column(_, ColName{2}), " ") in Table.TransformColumns(_, {ColName{2}, each x}){0}}})[Custom])
in
    #"Grouped Rows"