Text to Columns

Hi Everyone,

I would like to ask for you help how I can transform this unformatted text from the PDF file into a 6 columns format below. Thanks in advance!

Workflow

Accepted answers

@Rayyyyy sorry for the delay, PFA.

PFA

Can you provide the data please?

Please refer to the attached file. Thanks in advance

Okay, I transcribed the data for you.

To answer your query, you can use REGEX as I see your pattern is quite standard.

For the DR CR formatting, I will leave that to you to decide on what you want.

For anyone curious, the REGEX is:

^(.*?) (.*?) (.*?) (.*?) (.*?) (.*?)$

Sorry, just noticed that your data exists in rows of 2s. PFA latest.

@Rayyyyy sorry for the delay, PFA.

I really appreciate your help, can I ask for your expertise again?

I have another data that is the same with the previous one, the idea is just the same, I want to separate it by columns.

Thanks so much!