Hi @ADX ,
Thank you for posting your query in Microsoft Q&A Platform.
Union operator helps to achieve your case.
Kindly check below link to know about Union operator in Azure data explorer.
https://video2.skills-academy.com/en-us/azure/data-explorer/kusto/query/unionoperator?pivots=azuredataexplorer
Please let us know how it goes or if any further queries.