Good day everyone. I have one more question which I battle to solve. I have a column with various supplier stock codes (for example C-010, C-101, C-102). What I want is to create a column where those stock codes will be substituted with my own stock codes C-010 with G-15, C-101 with G-20, C-102 with G-25.
Is anything I can use to speed up the process?
Stock table with supplier's codesMy table where I have allocated my own stock number to each supplier's code