A new option in available when you import data in "Pivoted" mode: Exclude empty values.

This option will prevent you from generating unnecessary rows when you import data in a Transaction List.