mostly your invoices have multiple lines, in this case you will find empty cells on the same rows of the extra lines for example SO number, date, partner ... etc

you will have to use excel formulas to fill the gaps where all columns are filled in all rows containing data