Forum Discussion
Be careful when splitting cells in Power Query
I posted this in the BI and Analysis section before realising this dedicated Get & Transform section was available...
Power Query is fantastic at all sorts of wonderful data transf...
Wyn Hopkins I am surprised this is still not implemented yet and that this is the default behavior. Didn't know this was normal behavior until I found out about it while trying to split a column that had a lot more cases than 4. Thanks for sharing this solution.