As title, is anyone know how to split the data from 1 column into 2 columns? you may refer to below for the example. Thanks.
The Column I have
This is what I want to show my excel
I have no idea on how to do this after searching online. Hope someone can assist.