Convert csv to xlsx

[RAJESH1960]

Hello code experts,
I have this csv file which was converted from pdf. The columns are not in one order to get the data in a columnar view. It will take more than a hour to arrange each line in a particular format. JohnnyL's code has helped me a lot to get the columns in order in less than a second. I am facing one problem in one of the conversions. The code is not able to concatenate the Cheque No. to the Description in 3 different rows and in one of the lines it is not taking the amount. Hence the balances are not matching. I have colored the lines with errors. Need your expertise to correct the code. Thanks.
Conver CSV to XLSX.xlsm

 

[RAJESH1960]

Link to the csv file
CC Jan 2022.csv

 

[Alex Blakenburg]

Ideally @johnnyL will buy into this but you might want to unlock your VBA project in the file you provided to make it easier for others to help you or at least post the code you need help with modifying using the VBA code button.

 

[johnnyL]

@Alex Blakenburg, you gonna let a lil old password stop you from looking at the code?

 

[RAJESH1960]

@Alex Blakenburg, you gonna let a lil old password stop you from looking at the code?

? 123 is the password

 

[RAJESH1960]

Ideally @johnnyL will buy into this but you might want to unlock your VBA project in the file you provided to make it easier for others to help you or at least post the code you need help with modifying using the VBA code button.

Sorry, forgot to remove the password.

 

[RAJESH1960]

Wow! I never saw this Excel Articles before. It contains a world of knowledge of excel. It will be really helpful to learn and have fun..

 

[RAJESH1960]

I wonder why my query is not in the unanswered threads.?

 

[Fluff]

Because it has got replies.

 

[RAJESH1960]

Because it has got replies.

oh Ok. Just going through and trying to understand. Thanks