I'm trying to merge two excel files, here is the structure of the files: [A] [B] I want to add the column B from one file to another as column C, but the thing is that they have some rows under A ...
I have an Excel 2003 spreadsheet that I'm sorting on the first column, which is formatted as Text. The sort order is strange. Here's a "sorted" example. I've highlighted the anomaly. 120-BDXX ...