I have a column with nominal codes ie
Now if it begins with 1 I want to have a column which says Carlisle.
2 would be Egremont.
How would I go about doing column based on the first digit in another column in Power Query.
Solved! Go to Solution.