Forum Discussion

bigrig33's avatar
bigrig33
New Member
2 years ago

5000 Rows of Data with duplicate data

Apologies if something similar has been posted.    I have a table with 5281 rows of data. I have taken screenshot, data hid as priviliged. so the first two rows are the same person and he did two t...
General Comment
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi bigrig33 

You can group by the fullname and use Text.Combine() to combine them, you can refer to the following code to advanced editor.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlLSUUrUKEnVBNJGBkbG+ob6pkqxOlAJhKAZWNAYU7UhQgJd0ARTtRFYwhRVtbFSbCwA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, Type = _t, Date = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", Int64.Type}, {"Type", type text}, {"Date", type date}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Text.From([Date])),
    #"Grouped Rows1" = Table.Group(#"Added Custom", {"ID"}, {{"Count", each  Text.Combine([Type],","), type text}, {"aa", each Text.Combine([Custom],","), type text}})
in
    #"Grouped Rows1"

 Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.