Query and sort returning unwanted blank rows

Hi - I am trying to run a very simply query that graps three columns of data from one worksheet and posts it to another in the same Workbook. This works fine. I then try to add a sort into the query so that the data is sorted by the third column. This works - but the returned data has several unwanted rowes of blank data in it.

Can anyone solve this one for me?

The third column in the original data happens to be a Vlooklup formula on a third workshee in the same workbook. I thought this might be significantr, so tried it with values in the cells rather than formulas - but the same result.....

Really sorry about that, thanks for sticking with this, will post again as soon as I can to explain more, that may be tomorrow...

Blake7, I really hope you're still checking this! So sorry to be so slow.

OK - so, to clarify.

Worksheet 'Topline Queries' contains a query - and only a query - that seeks to return data that is on the next Worksheet 'ToplineReport3PLUK' to be precise, Columns G - I.The Query not only imports the data from these columns but also runs a 'sort in ascending order' of column I.

It manages to do both of these things (ie grab the data from the stated range) AND sort the relevant column accordingly, but when it does finally return this data to the 'Topline Queries' Worksheet, it inserts 22 blank unwanted rows before giving me the data ('Topline Queries Worksheet, Rows 2 -23).

This is the problem.

I think from memory that if I set up the quwery without the sort this would not happen, perhaps giving a clue as to the source of the problem, though to be honest I could not swear that I did try this since it has been a few days and I am inundated with work (not your problem I know!)

The Vlookup mention in the oroginal post may have been a red herring - but I will explain it here. The data in Worksheet 'ToplineReport3PLUK' Column I - ie the column for the sort - (and some in Column H) - comes as a result of a Vlookup formula that seeks data from a third Worksheet - 'Detailed Data', Column K. I was wondering aloud whether this might not be the source of the problem in some way....?

Hi Blake, many many thanks for that.

If you still have the energy for this, I can clarify something that I hope will help show you what I am trying to say. Apologies for not being clear. I am no techie.

"In the workbook you posted I cannot see how you got the data from sheet "TOPLINEREPORT3PLUK"
into sheet "TOPLINE QUERIES" as they are values only. As such I cannot comment why you are getting the 22 rows of blank data."

These values got there by what I am (wrongly?) calling a query - using SQL?

I have just learnt how to copy the code for what I asked it to do

SELECT `TOPLINEREPORT3PLUK$`.`AVAILABLE 12 PACKS NON PENDING`, `TOPLINEREPORT3PLUK$`.NO2, `TOPLINEREPORT3PLUK$`.`STRIPPED BOTTLES`
FROM `TOPLINEREPORT3PLUK$` `TOPLINEREPORT3PLUK$`
ORDER BY `TOPLINEREPORT3PLUK$`.`STRIPPED BOTTLES`

This is how I get the data there. And this is returning it - complete with sort - but with 22 rows of blank rows.

I can confirm that if I re-write it without the sort command it returns it with no blank rows to the cell I'd expect.

Is there a way to tell the SQL to carry on with the sort but not to insert the blank rows do you know??

Thanks, Matt

Aha! You learn something new every day. Or in my case - when it comes to messing with digital data - 100 new things. Thanks a lot for your time, apologies again, will re-post on an apt forum armed with new knowledge! Thanks.