Merge in PQE works but when I click table, it says table is empty

[Jahmia0616]

I have a contacts list from outlook that I need to merge with my funding list. I am trying to merge based off of comparing GroupName on the funding contacts tab and Company on the outlook contacts tab. When I merge, it shows there are matches but when I try to expand the data in the column that shows table 1, it says this table is empty. I tried changing the data type to text for both tables but that didnt work either. Can you let me know what else I can try to make sure the tables merge as expected?

Here is the link for the sample workbook: https://file.io/dk3dkmgI6Pj1

 

[alansidman]

Suggest you post to a different third party site. My Norton returns the following message.

BLOCKED BY

Dangerous Web Page Blocked
You attempted to access:

Deleted

Sharing files with file.io is convenient, anonymous and secure. Just upload files and share the links via email, SMS, Slack, Discord, etc. Easy-to-use REST API.

www.file.io

This is a known dangerous webpage. It is highly recommended that you do NOT visit this page.

 

[Jahmia0616]

My apologies, I wasn't aware that was a dangerous site. Can I use dropbox instead? Mr Excel Funding contacts example.docx

If not, I can upload the images of the data. Thank you!

 

[Jahmia0616]

My apologies, I wasn't aware that was a dangerous site. Can I use dropbox instead? Mr Excel Funding contacts example.docx

If not, I can upload the images of the data. Thank you!

Here is the correct link with the excel if dropbox is allowed: Sample Contacts data for Mr Excel.xlsx

 

[ursua]

there is no single match between groupname and company. you can verify it using vlookup function.