I am trying to import data to a previously created spreadsheet from a data
collection database that exports in a CSV format. My issue is that I have a
column of events numbered from 001 thru 100 with a corresponding column with
the quantity of daily events that have occurred and the event collection
database only exports the CSV file with data when it has a quantity of
greater than zero for an event. That is, some event numbers do not export
if no event occurred.
Is there a way I can re-order the csv file to include the event numbers with
a value quantity of zero? The events that do not appear in the exported csv
file vary from day to day.
Any suggestions would appreciated.
Jack