Forum Discussion
Solved
Splitting out data from a single cell into multiple columns
Good morning all, I have some data that I am importing into Power BI desktop and am using Power Query to transform it into something useful. The data comes from a Power Query online form, t...
The errors are due to following entries which don't follow the protocol. I have handled these now and worked out file can be downloaded from here - https://1drv.ms/x/s!Akd5y6ruJhvhuhBymtSFvgi2jtGl?e=33JnxK
The errors are due to following entries which don't follow the protocol. I have handled these now and worked out file can be downloaded from here - https://1drv.ms/x/s!Akd5y6ruJhvhuhBymtSFvgi2jtGl?e=33JnxK
Ah ok, that's frustrating. Thanks for your help, I think I should be able to manually edit those values in the source data to solve it. Thanks!