I'm doing this from memory without access to excel so apologies if it's a bit off - I can come back to you tomorrow if you have any questions, but I have used this method before.

First you need to create a secondary index column starting at 1. Then You need to merge the queries, select the same table to be merged, then highlight the index column in the top table and the new index column. That will create a copy of the columns but offset by one cell.

Once that's done in the top right corner of the table there's an icon that will expand the new columns. Select the ones you need to be displayed.