PowerQuery: Row with same ID, CONCATENATE image column into one row.

[santnok]

Hi

In PowerQuery I have a tabel that looks like the tabel under (TBL1). if you see under the ItemNo I have 1 or several same ID. So I need help to
make a colum that takes e.g. ItemNo: SHD3061 that have 2 rows of images and concatenate. So my result I hope to achieve is this (TBL2)

TBL2
[TABLE="width: 557"]
<tbody>[TR]
[TD]ItemNo[/TD]
[TD]Images[/TD]
[/TR]
[TR]
[TD]SHD3061[/TD]
[TD]/photos/SHD3061/SHD3061.jpg, /photos/SHD3061/SHD3061_4.png[/TD]
[/TR]
</tbody>[/TABLE]

From the tabel under you can see that the Image can be more than 1 for a ItemNo.

TBL1: Here is my result today I hope to fix
[TABLE="width: 557"]
<tbody>[TR]
[TD]ItemNo[/TD]
[TD]Images[/TD]
[/TR]
[TR]
[TD]SHD3061[/TD]
[TD]/photos/SHD3061/SHD3061.jpg[/TD]
[/TR]
[TR]
[TD]SHD3061[/TD]
[TD]/photos/SHD3061/SHD3061_4.png[/TD]
[/TR]
[TR]
[TD]SHD3062[/TD]
[TD]/photos/SHD3062/SHD3062.jpg[/TD]
[/TR]
[TR]
[TD]SHD3062[/TD]
[TD]/photos/SHD3062/SHD3062_pack.png[/TD]
[/TR]
[TR]
[TD]SHD3063[/TD]
[TD]/photos/SHD3063/SHD3063.jpg[/TD]
[/TR]
[TR]
[TD]SHD3063[/TD]
[TD]/photos/SHD3063/SHD3063_4.png[/TD]
[/TR]
[TR]
[TD]SHD3071[/TD]
[TD]/photos/SHD3071/SHD3071.jpg[/TD]
[/TR]
[TR]
[TD]SHD3071[/TD]
[TD]/photos/SHD3071/SHD3071_1.png[/TD]
[/TR]
[TR]
[TD]SHD3072[/TD]
[TD]/photos/SHD3072/SHD3072.jpg[/TD]
[/TR]
[TR]
[TD]SHD3072[/TD]
[TD]/photos/SHD3072/SHD3072_1.png[/TD]
[/TR]
[TR]
[TD]SHD3361[/TD]
[TD]/photos/SHD3361/SHD3361.jpg[/TD]
[/TR]
[TR]
[TD]SHD3361[/TD]
[TD]/photos/SHD3361/SHD3361_4.png[/TD]
[/TR]
[TR]
[TD]SHD3362[/TD]
[TD]/photos/SHD3362/SHD3362.jpg[/TD]
[/TR]
[TR]
[TD]SHD3362[/TD]
[TD]/photos/SHD3362/SHD3362_pack.png[/TD]
[/TR]
[TR]
[TD]SHD3461[/TD]
[TD]/photos/SHD3461/SHD3461.jpg[/TD]
[/TR]
[TR]
[TD]SHD3461[/TD]
[TD]/photos/SHD3461/SHD3461_4.png[/TD]
[/TR]
[TR]
[TD]SHD3462[/TD]
[TD]/photos/SHD3462/SHD3462.jpg[/TD]
[/TR]
[TR]
[TD]SHD3462[/TD]
[TD]/photos/SHD3462/SHD3462_pack.png[/TD]
[/TR]
[TR]
[TD]SHD3561[/TD]
[TD]/photos/SHD3561/SHD3561.jpg[/TD]
[/TR]
[TR]
[TD]SHD3561[/TD]
[TD]/photos/SHD3561/SHD3561_4.png[/TD]
[/TR]
[TR]
[TD]SHD3562[/TD]
[TD]/photos/SHD3562/SHD3562.jpg[/TD]
[/TR]
[TR]
[TD]SHD3562[/TD]
[TD]/photos/SHD3562/SHD3562_4.png[/TD]
[/TR]
[TR]
[TD]SHD3661[/TD]
[TD]/photos/SHD3661/SHD3661.jpg[/TD]
[/TR]
[TR]
[TD]SHD3661[/TD]
[TD]/photos/SHD3661/SHD3661_4.png[/TD]
[/TR]
[TR]
[TD]SHD3662[/TD]
[TD]/photos/SHD3662/SHD3662.jpg[/TD]
[/TR]
[TR]
[TD]SHD3662[/TD]
[TD]/photos/SHD3662/SHD3662_pack.png[/TD]
[/TR]
[TR]
[TD]SHD3862[/TD]
[TD]/photos/SHD3862/SHD3862.jpg[/TD]
[/TR]
[TR]
[TD]SHD3862[/TD]
[TD]/photos/SHD3862/SHD3862_Box.png[/TD]
[/TR]
[TR]
[TD]SHD3863[/TD]
[TD]/photos/SHD3863/SHD3863.jpg[/TD]
[/TR]
[TR]
[TD]SHD3863[/TD]
[TD]/photos/SHD3863/SHD3863_Box.png[/TD]
[/TR]
[TR]
[TD]SWB7140[/TD]
[TD]/photos/SWB7140/SWB7140.jpg[/TD]
[/TR]
[TR]
[TD]SWB7140[/TD]
[TD]/photos/SWB7140/SWB7140_0.jpg[/TD]
[/TR]
[TR]
[TD]SWB7140[/TD]
[TD]/photos/SWB7140/SWB7140_1.jpg[/TD]
[/TR]
[TR]
[TD]SWB7140[/TD]
[TD]/photos/SWB7140/SWB7140_10.jpg[/TD]
[/TR]
[TR]
[TD]SWB7140[/TD]
[TD]/photos/SWB7140/SWB7140_11.jpg[/TD]
[/TR]
[TR]
[TD]SWB7140[/TD]
[TD]/photos/SWB7140/SWB7140_12.jpg[/TD]
[/TR]
[TR]
[TD]SWB7140[/TD]
[TD]/photos/SWB7140/SWB7140_13.jpg[/TD]
[/TR]
[TR]
[TD]SWB7140[/TD]
[TD]/photos/SWB7140/SWB7140_14.jpg[/TD]
[/TR]
[TR]
[TD]SWB7140[/TD]
[TD]/photos/SWB7140/SWB7140_15.jpg[/TD]
[/TR]
</tbody>[/TABLE]

Hope it is possible to do without coding directly in the Advanced Editor

Hope somone can help me out here

Thanks for all help

 

[santnok]

Thanks

 

[sandy666]

welcome