How to remove a CR and LF form txt file

I have a .txt file with 147693 lines that I need to open in MS Excel.
I need to remove 6 pairs of CR and LF at the end of the first 6 lines,
then skip one (which is a legitimate CR, LF)
then continue to the following 6 pairs.

Any help ho to do that?
I understand I will have to write a macro to do this, but have no idea hoe to find and remove / go to next CR to remove.

I tried this in Notepad ++
It runs fine if I do 50 at a time when running a macro, but Notepad ++ gets confused if I try to do more than 500 at a time.
Ideally I would like to do it in Excel in one go.

I can provide the original file; truncated after say 1000 records and then the matching Microsoft Excel file that was successfully converted..If needed.

Any advice will be appreciated very much

Frits

Originally Posted by Glenn Kennedy

Hi there... and welcome to the Excel Forum.

Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

Click on GO ADVANCED and use the paperclip icon to open the upload window.

The paperclip icon

Hi Glenn,

Thanks for the reply:

Attached is the PDF I export and the Excel file I would like to generate from that.
Currently I take it through a series of steps including Notepad ++.

Kind Regards

Frits