ExcelBanter - Query into specific columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Query into specific columns (https://www.excelbanter.com/excel-discussion-misc-queries/36917-query-into-specific-columns.html)

Gules

Query into specific columns

Hopefully, this is a simple problem:

I have built a sheet with columns A-H. I query a separate Excel sheet that
contains 4 columns of data that I need. I would like the data imported into
columns A,B,E & G. But the query returns the data to A,B,C & D. What can
I do??

Thanks

All times are GMT +1. The time now is 06:59 PM.