Importing blank rows from excel spreadsheets
Operating system version
Mac OS X 10.7.1
Description of the issue
I am creating a scientific database. To start I need to import the last 35 years of data from excel spreadsheets. However, whenever I import a spreadsheet, the blank rows at the bottom of each spreadsheet are also imported. This is adding over 100 blank records for each spreadsheet.
Any idea how to fix this without having to go into every spreadsheet and delete the blank rows?