I have a long list of data that I would like to separate into different columns.

Attached is my example file
lists to columns.xlsx

hope you can help

I am happy to use either formula or vb code

regards

kevin