Combine data from 3 different spreadsheets

Hi.  Yes I do.  If I union the Americas with either of the other tables I get a blank, but union them together it's fine.  The issue appears to be with the Americas table.  When I look at the table in transform I see all the data.  When I save that and switch to table view I see nothing.

I've been to my excel file and checked the column formats, all seems to be OK.  I get the files delivered every month.  I went back to a previous file and that is still the same.  The spreadsheet is connected to external data sources (but then so are the others) so I disconnected it from those data sources.  Always the same. I see the data in the spreadsheet. I see the data in transform view, I don't see the data in the table view.   

A case of 2 steps forward 1 step back.  Why I couldn't see the data in the Americas table was because there were thousands of blank rows.  I deleted them and all seems OK. The issue is now as follows.

In order to create the union, I use data transform to delete some columns and move others about. When I look at the columns in transform I have the same number of columns in the same order in each table.  When I perform the union it seems to forget the order that I put the columns in and I get a mix of data in each column.  If I can just fix this I am all good.  Any further suggestions?

All fixed now and working perfectly.  I just started again and used a different table as my starting point.  I moved the columns around in the other tables and it worked. Not sure what the issue was.