Forum Discussion
Splitting out data from a single cell into multiple columns
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
Hi Vijay,
Thanks, that worked.
I do still have a couple of issues though.
Some rows there is still a date stamp in the "status" column - is this because there is a different delimiter that has got in somehow?
Result after current transformations.
Cells before transformations - the top 2 cells format correctly post transformation, the bottom one doesn't.
Also, you'll see that int eh first photo there are some errors post tranformation. Those are as a result of the data being input incorrectly. Is there a way to autmatically remove any rows that have either a null value or an error value in those columns?
Can you copy and paste some sample data in Excel and post Excel to Onedrive/Googledrive and post the link here? Make sure to include the rows which give out errors.
Only that column which contains these data will do good.
Hi Vijay, I don't suppose you've had a chance to look at this?
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