How to Create combined named range using two or more existing named range?

I've tried few techniques with a bunch of nested formulas but the range obtained like that didn't let me spill it afterwards. So, I had to manually select the range of the columns and use Ctrl+Shift+Enter to create that combined named range's list.

To elaborate more, Let's say,

I have two named ranges already, [Range1] & [Range2], which could be from the same sheets or diff sheets in a single workbook but for both of them, the scope is set for the whole workbook.

So, I'm looking for a solution that lets me create a new Range, [CombinedRange], that'll show all the cells of those two individual ranges at once and spill when I use functions like unique or sort.

Thank you so much. Worked so fine!!