Forum Discussion
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...
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],"; ")
let
Source = Excel.CurrentWorkbook(){[Name="JerrysTable"]}[Content],
GroupedRows = Table.Group(Source, {"ID"}, {{"Item", each Text.Combine(_[Item],"; ")}})
in
GroupedRows