Text to Columns

[Rayyyyy]

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!

[Rayyyyy]

Hi @caltang ,

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!

[caltang]

Can you check your bank ref again?

Bank reference	Customer reference
	SWIFT STMT SER C
230914209434168	GHK500643580
HK115093HB198657	P8089726
HK115093HB198657	P8089726
HK115093HB265585	P8089723
HK115093HB265585	P8089723
HK115093HB265586	P8089724
HK115093HB265586	P8089724

Not sure how the SWIFT thing is there... Can you clarify or give more data like that?

[caltang]

Happy to help, but need more info pls. You can msg me for more details if not comfortable to share here. Thanks!

[Rayyyyy]

Hi @caltang ,

this is what the pdf statement looks like. Every month the Bank Reference of the swift transactions  is blank and it is appearing in no particular date. sometimes it will appear on the middle of the month sometimes at the end month. Thanks

[caltang · Accepted solution]

Hi @Rayyyyy 

PFA