Forum Discussion
RingoSun
Helper II
Helper IISplitting a text in a column
Inside a column I have values such as: Column Test Nice Product Test 1 Product Test 2 Good Product Test 3 Product I want to do the splitting inside the same column (I don't wa...
I have tried to use certain transfomations in Power query, Please let me know if this is what you are looking for.
I will try to explain the working later:
https://drive.google.com/file/d/1oweJyDKNJ5JqK6UNTIrWxPRCUhyb7fFX/view?usp=sharing
Ashish_Mathur
Super User
Super UserHi,
In the Query Editor, select this column and click on Replace Values. Find for Product i.e. space and Product. Click on Replace.