Extract data by skipping blanks into a summarized form
Just set up a "New Database Query" based on your input data. You can
use SQL similar to this:
SELECT `Sheet1$`.Field1, `Sheet1$`.Field2, `Sheet1$`.Field3,
`Sheet1$`.Field4
FROM `Sheet1$` `Sheet1$`
WHERE (`Sheet1$`.Field1<' ')
OR (`Sheet1$`.Field2<' ')
OR (`Sheet1$`.Field3<' ')
OR (`Sheet1$`.Field4<' ')
|