Merge cell in excel 2007

[ajen7118]

Hi,

Could you please take a look at attachment and advise the best to resolve?

I would like to show merged cell when output to excel 2007.

thank you

[ajen7118]

anyone can help this?

thank you all so much

[New_Guy]

Hi,
Once you place a list inside the cell it will create a seperate cell. I think eeven a singleton will do the same. Did you try a layout calculation. And also what are you trying to show in that list.
Good luck
New guy

[ajen7118]

Hi New Guy,

I joined two of my queries into one and used the data item directly instead of inserting a list and setting up master detail relationship between two queries.

It resolved the issue.

thanks.