ExcelBanter - MS Query results into merged rows

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

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

- - MS Query results into merged rows (https://www.excelbanter.com/excel-discussion-misc-queries/258939-ms-query-results-into-merged-rows.html)

ineedexcelhelp

MS Query results into merged rows

Hi,

I am using Excel 2003 on Windows XP with SQL Server 2005, I am using Ms
Query to return a set of data and want it to go into a range of cells.
However the cells are merged and the MS Query results unmerge the cells.

Is there any way in which to preserve the cell merging?

Regards

All times are GMT +1. The time now is 09:55 PM.