Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two sheets, a and b, which have a common identifier which I am joining on. The issue is when I do the join there are some entries which should be matched but are not coming over in the join. The odd thing is if I take these entries out of sheet b and put them in a separate spreadsheet then the join works as expected. It points to some sort of issue with my excel sheet. I have removed page breaks etc and tried copying all the data from sheet b into a new sheet to no avail.
Strange one but any one any ideas ?
Are you sure the are not additional spaces somewhere in your data?
Could you post your data or app?
Thanks Robert. What do you mean by additional spaces in the data ? Could you provide an example of what you mean ?