How to split the excel in different columns

Help
1

Hi guys,
i have one excel which contains all the data in one column,i want to split data in different column like Date,Transcation details,debit,credit,balance.attach here my Excel file please help me out to get result test.xlsx (9.5 KB)

2

guys if u have any idea related this pls do reply