I have an excel data (please see below), with merged rows cell,
Please help which load script should i use, so that when load it will look like this (please see below)?
thanks in advance.
LOAD If( IsNull(a), Peek(a),a) as a,
(ooxml, embedded labels, table is Sheet1);
If( IsNull(a), Peek(a),a) as NewValue
Drop Table Data;
Thank you much!
Retrieving data ...