How to merge data from various cells in the column into single cell

[Aden123]

How to merge the data from

Product	Machine
A	1
A	2
A	3

to become

Product	Machine
A	1,2,3

[Vijay_A_Verma]

Insert this step

= Table.Group(Source, {"Product"}, {{"Machine", each Text.Combine([Machine],","), type text}})

[ChielFaber]

The instruction on the following page will give you the desired outcome:

https://gorilla.bi/power-query/group-by-to-concatenate-text/

It uses a group by function in combination with the Text.Combine function. It will give you the result your looking for and you can just follow the steps and explanation.