I have 2 parallel (side by side) same-height Excel tables with a completely blank column (no data, nor header) in between them. The rows of a table correspond to the same rows of the other table (so they must stay parallel), but no formulas link them together.
What is the simplest way to sort the entire range (both tables) by any column in either table?
Background: the document is regularly uploaded into a program in which only the left table is needed. The program starts at A1 and stops the upload range at the first blank column, so the column in between must be blank.
EDIT: Simple example - the left table gets automatically uploaded and the right table is there for additional information (for the internal group that has access to the source files). The rows correspond to each other, so sorting by any column in either table should also sort the other table.
And these must be formatted as tables for the benefit of structured references (which are obviously more complex than this simple example):
CURRENT WORKAROUND: Keep data in simple ranges, allowing to filter across entire range including the blank columns.
Unfortunately, it does sacrifice readability of structured references: