Fixing Half-Empty Columns in Export Files

I see half-empty columns in the export file. How can I fix it?

This is the default behavior of export modules. Duplicated data is not automatically added to child rows of the parent entities for the purpose of optimizing database queries during the export process and reducing the size of the final export file.

If you do require child rows to be filled with the duplicated data, in the export profile, open the File Settings tab and enable the Duplicate Parent Entity Data setting; this should do the trick: