Export to excel issue

I have one issue when exporting to Excel. When using the 'data only' option it is ok the columns get smaller and user complains.

Using regular option ( the first one). IT Created an excel with lots of blank cells intermittent. (that is why we use the 'data only') but is there a way to format

the CR in such a way that will not produce this issue?