Splitting cell by position

@anjeesanjeet how many rows do you have currently ? Could you share them here to investigate them more in depth? Otherwise, it seems to be difficult to provide solutions without enough data at hand.

@aworker Currently I am working on the dataset with 16 rows which I have given above(attached) with the query. But This data is just the trial. I am processing the data and the original dataset has around 26100 rows. I can share the dataset here due to the Privacy of the dataset. But all looks similar to the dataset which I have given above.

Hi @anjeesanjeet

Sorry for my late reply and thanks for your last post. I believe that without having access to the whole ~26K rows of data to investigate it further, it is hard to provide you with zero-error solution as demonstrated by @ArjenEX in his exercise.

Best
Ael

1 Like