distribute data PQ for the same sheet instead of add many sheets for multiple pages

[Hasson]

Hi guys

why when use PQ will split data for multiple sheets when contain multiple pages for the sheet ?
and why when I use PQ will add new sheet . why doesn't implement for the same sheet instead of add new sheet?
is there any choice to show whole data in the same sheet when used PQ?
thanks

 

[Hasson]

@smozgur
well I think to find out what's the problem , but for me is disappointed

so when use one table separately then will option work as you said , if I try use Append queries option for multiple tables to make as one then will enforce me add in new sheet and create multiple sheets for each Table .
It is frustrating
thanks for your guiding me .

 

[smozgur]

I focused on simply loading a "single" query situation. Now it makes sense why it didn't work for your case.

Glad to hear it is solved. I would mark @jdellasala's comment as the answer to this question since it perfectly explained and solved your question - post #10.