Is there a way to add 2 tables (2 separate queries) onto one Excel sheet?

[dolphin18]

Hello,

I am wondering if there is a way to display 2 tables on 1 Excel sheet. I have 2 separate queries that contain the same columns but different criteria within the queries. The user wants to be able to track current open orders (Table 1) and then to track upcoming orders that are on their radar (Table 2). I have the first query set up to where if the 'Order Date' or the 'Vendor' is filled out then it will populate within Table 1. However, if the 'Order Date' or 'Vendor' is blank then it will not be pulled into Table 1. Table 1 is set up like this because there are several orders within Table 2 that have blank 'Order Date' and 'Vendor' fields. I want to keep them as tables because the user wants to be able to filter within both tables separately. For example, say they want to see just Lemon orders from Table 1 and then Plums in Table 2.

I have tried appending them and I got it to display how I want, however, they are in 1 table and I can't filter separately.

Table 1:

ID (Drop down filter)	Description (Drop down filter)	Order Date (Drop down filter)	Vendor (Drop down filter)	Order By (Drop down filter)
122	Apples	4/16/25	Walmart	4/30/25
145	Oranges	8/25/25	Target	2/1/26
890	Lemons	10/3/25	null	12/1/25
560	Lemons	2/8/25	Walmart	1/10/25

Table 2:

ID (Drop down filter)	Description (Drop down filter)	Order Date (Drop down filter)	Vendor (Drop down filter)	Order By (Drop down filter)
132	Peaches	null	null	5/1/25
152	Pineapples	null	null	12/23/25
900	Plums	null	null	4/16/26
854	Blackberries	null	null	7/21/25

The outcome I would like:

ID (Drop down filter)	Description (Drop down filter)	Order Date (Drop down filter)	Vendor (Drop down filter)	Order By (Drop down filter)
122	Apples	4/16/25	Walmart	4/30/25
145	Oranges	8/25/25	Target	2/1/26
890	Lemons	10/3/25	null	12/1/25
560	Lemons	2/8/25	Walmart	1/10/25
On the Radar
ID (Drop down filter)	Description (Drop down filter)	Order Date (Drop down filter)	Vendor (Drop down filter)	Order By (Drop down filter)
132	Peaches	null	null	5/1/25
152	Pineapples	null	null	12/23/25
900	Plums	null	null	4/16/26
854	Blackberries	null	null	7/21/25

I haven't been able to find much on this topic. Any help or suggestions would be greatly appreciated! Thanks!

[v-nmadadi-msft]

Hi @dolphin18 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Cookistador · Accepted solution]

My suggestion would be to add a calculated column in each table in Power Query, called status for example

For table1, status = current orders and For table2, status = upcoming orders

then you can append

You will have the following result

If you need more help, do not hesitate to ask 🙂

[dolphin18]

Thank you for the suggestion! When I append, do you know of a way to add in another row as a header to separate between the 'upcoming orders' and 'current orders', so the user is able to further filter the data separately once the table is displayed? I have been able to add in a blank row by grouping by the upcoming orders' and 'current orders', but I just don't know how to add in the extra filter capability.

[Cookistador]

the issue with that, you are not sure that the data will be filled in the right order

Or if the people start to play witht the sort, you won't keep the right order

but the approach of adding a new column, you can build a matrix like this one to have everything in the right "table" or you can create two tables and apply a filter = "current orders" and on the second table a filter = "upcoming orders"

[dolphin18]

Thank you! @Cookistador. I ended up using the calculated column and then having the user filter on their end. Thanks for the help!