Populate Merge data based on unique Column value

[Anonymous]

Hello mate,

I need your kind help.  As per the below picture, I want to get the Output table from input unstructured data.  Here you can see the value will fill down based on the PO number. 

I want to do this with Fill down. This option fills down for other POs like B, and D. But I want Value will be filled down based on PO number only. 

[Vijay_A_Verma · Accepted solution]

Use below code. Replace Source appropriately.

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Filled Down" = Table.FillDown(Source,{"PO"}),
    #"Grouped Rows" = Table.Combine(Table.Group(#"Filled Down", {"PO"}, {{"All", each Table.FillDown(_,{"Value"})}})[All])
in
    #"Grouped Rows"