First, we must clearly know what you are expecting for ‼
Your thread title is about removing blank rows, too easy even for a beginner …
But what a surprise once the thread is opened, the source file is not a workbook and it's very not blank rows to remove ‼
So at this point when it's not very accurate some helpers directly move to the next thread …
As it is very not difficult to join a reduced source csv file, just download Notepad++ for example
if only really a text csv file is your source file, the first question I asked for …
And we have no idea about your final file so we won't guess so we expect a complete crystal clear description of your need
(what is the header of the data to check if blank for example) with a reduced source csv file …
Again, if the final file is a csv file, according to the huge source file without any link with Excel so it's very not the best tool
but why not as Excel if often the swiss knife of losts …
Yes PowerQuery is a way like VBA is another one like any faster language like C, Python, …
Bookmarks