I have an XLS worksheet that copies cells from a different worksheet in the
same workbook using the following function "=T(UPPER(<other worksheet
name!<other worksheet cell)). The formula is copied throughout the
worksheet using relative cell reference. When I save the worksheet as a csv
file all of the records that have no data are also saved. What I end up with
in the csv file looks something like this:
data,data,data,data,
,,,,

How do I tell Excel to not save the empty rows?