Forum Discussion
Solved
Merge query based on 2 variables
Hi guys, I'm trying to get information from 1 table lined up to another table. One table shows all transactions we have in our business. The other is a manual sheet that has collected issues th...
Yes, You can concatenate both the column "Mobile no and Date" and go ahead.
Yes, You can concatenate both the column "Mobile no and Date" and go ahead.
Unfortunately I struggled combining the columns as text and date did not go together. Even after converting both to text, my data had some entries that weren't in exactly the same format and the merging of queries failed.