I m trying to concatenate a column containing SKUs that don t follow a pattern (some fields with numbers only while others with both text and number) and another column which contains only text. Does anyone know if it is possible to do that in Power Query? Since there is fields with different formats in the first column (e.g. OCI-110; 1354; etc.), none of the methods worked for me.
I ve tried the conventional methods to make the concatenation. Perhaps a conditional concatenation could work, however I have no idea about|a M synthax for this.
Thanks!