Forum Discussion
Column not grouping correctly
So, I have a data source from a survey that has numerous answers for one field, separated by semi-colons, like this: I have managed to split and sort the answers like this (below), but you can...
Thanks for your help... but I tried just using the "Trim Text" option in Power Query to remove the space from the start of the text after splitting, which worked a treat. Simple solution... just took me a while to find it!