Forum Discussion
Mahamood0218
Helper II
Helper IISplit the columns and apply the sort
Hi Experts , i have a two columns(Sub_group_id and Sub_group) i need to split the Sub_Group data Full-Time/Expert as "Full-Time" and Part-Time/Exempt as "Part-Time" and i have three clomuns d...
Hi Mahamood0218 .
You can split columns using delimeter, in delimeter you can specify as "/".
Refer the below link for more info.
https://docs.microsoft.com/en-us/power-query/split-columns-delimiter
Thanks,
Sanket
If this post helps, then mark it as 'Accept as Answer' and give it a thumbs up.