Hello all,
I'm wondering how, in a M script (Power Query), I could split an excel table like the following
COL
A
B
C
D
E
F
G
H
and concat each cell content 3 by 3 (with a comma separator).
Result expected : a new table like this (that I could reuse in the next steps of the script)
COL RESULT
A,B,C
D,E,F
G,H
Is it possible to do that ?
Thank you
I'm wondering how, in a M script (Power Query), I could split an excel table like the following
COL
A
B
C
D
E
F
G
H
and concat each cell content 3 by 3 (with a comma separator).
Result expected : a new table like this (that I could reuse in the next steps of the script)
COL RESULT
A,B,C
D,E,F
G,H
Is it possible to do that ?
Thank you