I have a query in Access that has all the data I need but it is strung out
over many cells when I click on the tool that sends it to be analysed in
Excel option under tools it goes right accross the page. The client wishes
to see it as they do today which is a spreadsheet of about 3 columns and 6
rows. Is there a way on the import I can tell excel to take this data and put
it in the 3rd row in the 2nd column and this data goes to 1st row in the 3rd
column etc.?

I have not used many of the Excel features yet so please keep it simple if
possible.

Thanks for your assistance.