Problem with my automation

To add, my column also not in a right way. Meaning that in one column there is two things. During my manual using excel, im using text import wizard before convert into excel