Forum Discussion

jerryr125's avatar
jerryr125
Icon for Helper IV rankHelper IV
1 year ago
Solved

Single record with concatenated data (field)

Hi -  I have the following data in which I would like to run through Power Query to create a single record for each ID.   Example:   Data Start (Table A) ID Item 1 Pizza 1 Hamburger...
Show and Tell
  • Omid_Motamedise's avatar
    Omid_Motamedise
    1 year ago

    right click on the Id column and pick group by command and make the setting presented in the next image

     

     

     

    press ok will result in error in the new column as it is not posible to apply sum operation on the text as the next

     

     

     

    in the formula replaced list.sum by Text.combine to reach the next

     

     

     

    if you want to use seperator also write the formula as bellos.

     

    Text.Combine([Item],"; ")

     

     

     

     

     

     

p45cal's avatar
p45cal
Icon for Solution Supplier rankSolution Supplier
1 year ago

 

let
    Source = Excel.CurrentWorkbook(){[Name="JerrysTable"]}[Content],
    GroupedRows = Table.Group(Source, {"ID"}, {{"Item", each Text.Combine(_[Item],"; ")}})
in
    GroupedRows