Forum Discussion
Change letter and numbers
As variant that could be done by Power Query - split Manufacturer SKU texts to lists, expand to rows, merge with mapping table, combine back to texts
Query is in attached.
SergeiBaklan I believe something goes wrong in the "Expanded CharMap1" step and subsequent grouping (Text.Combine). I seems to throw the order of characters around. For example, "TQC603" should be "TC6Q03".
You are right, thank you. Forgot to fix table in memory before expanding. Here is by adding the index, Table.Buffer() will work as well.
SergeiBaklan Expression.Error: 5 arguments were passed to function which expects between 2 and 4.
Details:
Pattern=
Arguments=ListFifth explicit argument defining the data type was added to Table.AddIndexColumn() recently, somewhere mid summer. On older versions of Power Query you shall delete it, but I'd recommend to update Power Query instead, otherwise you'll have compatibility issues in future.
