R
Rif
I need to overlay databases. I need to have a CSV that will not "bubble" or
shift up the data with blank rows.
The software I use has recently been updated so that it will not allow the
header row to be removed from the overlay (argh!).
Right now, unless I merge two columns with one being a "not null" column,
the overlay is bad.
For example, an Excel sheet with any blank values at the topmost section of
rows (with no header and no leading value) will always output nonblank values
"bumped up" towards the top.
Is there a real workaorund for this aside from hard whitespace or doubling
up of column imports? I don't mind a third party tool or add-in.
shift up the data with blank rows.
The software I use has recently been updated so that it will not allow the
header row to be removed from the overlay (argh!).
Right now, unless I merge two columns with one being a "not null" column,
the overlay is bad.
For example, an Excel sheet with any blank values at the topmost section of
rows (with no header and no leading value) will always output nonblank values
"bumped up" towards the top.
Is there a real workaorund for this aside from hard whitespace or doubling
up of column imports? I don't mind a third party tool or add-in.