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
<tbody>
</tbody>
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
<tbody>
</tbody>
Hope it is possible to do without coding directly in the Advanced Editor
Hope somone can help me out here
Thanks for all help
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
ItemNo | Images |
SHD3061 | /photos/SHD3061/SHD3061.jpg, /photos/SHD3061/SHD3061_4.png |
<tbody>
</tbody>
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
ItemNo | Images |
SHD3061 | /photos/SHD3061/SHD3061.jpg |
SHD3061 | /photos/SHD3061/SHD3061_4.png |
SHD3062 | /photos/SHD3062/SHD3062.jpg |
SHD3062 | /photos/SHD3062/SHD3062_pack.png |
SHD3063 | /photos/SHD3063/SHD3063.jpg |
SHD3063 | /photos/SHD3063/SHD3063_4.png |
SHD3071 | /photos/SHD3071/SHD3071.jpg |
SHD3071 | /photos/SHD3071/SHD3071_1.png |
SHD3072 | /photos/SHD3072/SHD3072.jpg |
SHD3072 | /photos/SHD3072/SHD3072_1.png |
SHD3361 | /photos/SHD3361/SHD3361.jpg |
SHD3361 | /photos/SHD3361/SHD3361_4.png |
SHD3362 | /photos/SHD3362/SHD3362.jpg |
SHD3362 | /photos/SHD3362/SHD3362_pack.png |
SHD3461 | /photos/SHD3461/SHD3461.jpg |
SHD3461 | /photos/SHD3461/SHD3461_4.png |
SHD3462 | /photos/SHD3462/SHD3462.jpg |
SHD3462 | /photos/SHD3462/SHD3462_pack.png |
SHD3561 | /photos/SHD3561/SHD3561.jpg |
SHD3561 | /photos/SHD3561/SHD3561_4.png |
SHD3562 | /photos/SHD3562/SHD3562.jpg |
SHD3562 | /photos/SHD3562/SHD3562_4.png |
SHD3661 | /photos/SHD3661/SHD3661.jpg |
SHD3661 | /photos/SHD3661/SHD3661_4.png |
SHD3662 | /photos/SHD3662/SHD3662.jpg |
SHD3662 | /photos/SHD3662/SHD3662_pack.png |
SHD3862 | /photos/SHD3862/SHD3862.jpg |
SHD3862 | /photos/SHD3862/SHD3862_Box.png |
SHD3863 | /photos/SHD3863/SHD3863.jpg |
SHD3863 | /photos/SHD3863/SHD3863_Box.png |
SWB7140 | /photos/SWB7140/SWB7140.jpg |
SWB7140 | /photos/SWB7140/SWB7140_0.jpg |
SWB7140 | /photos/SWB7140/SWB7140_1.jpg |
SWB7140 | /photos/SWB7140/SWB7140_10.jpg |
SWB7140 | /photos/SWB7140/SWB7140_11.jpg |
SWB7140 | /photos/SWB7140/SWB7140_12.jpg |
SWB7140 | /photos/SWB7140/SWB7140_13.jpg |
SWB7140 | /photos/SWB7140/SWB7140_14.jpg |
SWB7140 | /photos/SWB7140/SWB7140_15.jpg |
<tbody>
</tbody>
Hope it is possible to do without coding directly in the Advanced Editor
Hope somone can help me out here
Thanks for all help