Can you provide a sample workbook?
Cross datasource (in your case two different Excel files) join is not available in Tableau Desktop 9.
Please wait for the coming soon Tableau Desktop 10.
Data blend (see Blend Your Data ) is available cross datasource, but not at the row level.
I'm not sure if it works for you.
Thanks John for your response. Do you want me to send the data in excel or tableau?
Both would be even better.