Importing 1 cell of data takes up 2 cells?

Originally Posted by mar504

I've got a database with computer inventory and I want Excel to run two queries that gives me a count of desktops and laptops which I've already done.

But the import uses two rows even though there is only one row of data (the number of desktops). For aesthetic reasons my laptop count is in the one row down from the desktop count, but I can't use that cell to import data now, it's grayed out.

I know the easy way is to shift things around, but I want to know why it's taking up 2 cells with only 1 cell of data.

I DO have "Include field names" turned off (it would normally take up 2 cells if it was on, one for the field name and one for the data). But it seems like if it's turned off it shouldn't take up an empty cell.

Anyone know the answer to this?

perhaps zipping a sample workbook will let somebody find the problem,