issue in unstructured data - Alteryx

[Soni]

Dear All, 

Can anyone please help me in how to convert an unstructured data into the required format as I'm working with an attendance data which has been fetched through oracle.

While importing the data, it's so difficult to work on it. So, is there any method or solution for it to make it in a specific format as required becoz in excel we can't clean manually a huge data....

PFA also their are 21 files as same on which I have to work.

Hopefully waiting for the response.

Thankyou.