Forum Discussion
Using a trim function
Hello, I have a set of data that looks like this, and want to convert this column into two seperate ones with "State" and "Status" Alaska - Active Texas - Active Nebrask...
Hello there! Why not perform these transformation in the Power Query Editor with the help of the "Split column by" --> "Delimiter" --> and then select "-"?
Hello there! Why not perform these transformation in the Power Query Editor with the help of the "Split column by" --> "Delimiter" --> and then select "-"?