excel After loading
If the load is kind merge excel spaces , the spaces How do I handle this? There must fill in the data space just above.
Do you want to see the extra spaces after the data is loaded? If yet try adding a SET Statement in your load
LOAD If( IsNull(a), Peek(a),a) as a,
(ooxml, embedded labels, table is Sheet1);
Check the below thread.
Load Excel with merged row cell data
Retrieving data ...