Merge Data not picking up appended data

[Anonymous]

I have a query (Query A) and I appended a query (Query B) to the end of it. In another query (Query C) I am doing a merge to Query A based on a unique identifier in Query A. However, when I do the merge it does not pick up any of the data I appended to Query A from Query B. Any way to get the data from Query B to be pulled by the merge statement from Query C to Query A? Example steps below.

Note, that I know I could just do a second merge from Query C to Query B and do some additional calculated steps to get to the same spot but I would prefer not to go that route as the data is quite large and adds additional time to the refresh time.

Example layout:

Query A (Database Query):

Project Code | Project Manager

Query B (Manual Excel Spreadsheet):

Project Code | Project Manager

Append Query B to Query A

Query C (Master Table):

Project Code | Merge to Query A to get Project Manager

[HotChilli · Accepted solution]

It looks like Query B (Project Code) isn't matching. 

You can examine the data with the newish 'column distribution' , 'column profile' etc features and see what's up with the data( there might be spaces or hidden characters in the field used to merge) so it'll need to be cleaned up.

OR the merge is done with an inner join and there are no matches