Ok this is going to seem a little pointless, but it's part of a larger document which I can't share - mainly because i'm trying to rebuild it and it doesn't fully exist at the moment.
Example.xlsx

In the attached example you'll see two identical tables, one with data and one without - where I only reference one table assume the corresponding location on the other will have the same rules applied.
What I want is for the data from the second table to appear in the first but in order by the first column (AE:AF/A:B). I know there's the simple sort and filter functions, but in the final document the client will not have the ability to use them.
The data in table 2 is extracted from a 3rd party source, and the majority of the time it comes through out of order - so in the final document table 2 will be in the background and table 1 will be the table that the client sees.

I've tried to fill out the table as if it were a real one - however there are very few occasions where all 24 rows are used; it's usually between 4 and 10.
There may also be the odd occurrence where a value in column AE:AF is missed (i.e. you could have 1-4, missing 5, and have 6-8) In these circumstances I would require the missing value(s) to remain missing and not leave a space in the table.

Columns A:B, C, AA:AC are all number values
Columns J:Y will be either Y or N
For Columns D,E,F only one of the 3 cells on the same row will have a Y at any one time - the same applies to G,H,I (there will be no Ns)

Any questions let me know, as this is a work project i'll probably only respond during work hours.
Thanks in advance.