Reverse of Fill Down in PQ

[sadath]

Hi

How can i do the reverse of Fill Down in PQ.

ie remove the duplicate and keep only the first one in a column (Eg "Store" in the below code)


let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Store", type text}, {"Sales", Int64.Type}})
in
#"Changed Type"

 

[Ron Coderre]

Using your posted example as the start of my Power Query code....
Here's what I did:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    SetDataTypes = Table.TransformColumnTypes(Source,{{"Store", type text}, {"Sales", Int64.Type}}),
    AddedIndex = Table.AddIndexColumn(SetDataTypes, "Index", 0, 1),
    GroupByName = Table.Group(AddedIndex, {"Store"}, {{"Group", each _, type table}}),
    AddGroupIndex = Table.TransformColumns(GroupByName, {{"Group", each Table.AddIndexColumn(Table.Sort(_,"Index"), "GroupIndex",1), type table}}),
    ExpandedGroup = Table.ExpandTableColumn(AddGroupIndex, "Group", {"Sales", "Index", "GroupIndex"}, {"Sales", "Index", "GroupIndex"}),
    SetNonFirstGroupRecordToNull = Table.FromRecords(Table.TransformRows(ExpandedGroup,(record) => Record.TransformFields(record,{"Store", 
        each if record[GroupIndex] =  1 then _ else null})))
in
    SetNonFirstGroupRecordToNull

Am I on the right track?
Is that something you can work with?