![]() ![]() In this example, there are extra products in workbook2, but the solutions will work if either workbook has extra columns. It has Product Code and then other columns. It has Product and then three columns of data. If you have Windows versions of Excel 2010 or Excel 2013, you can download the Power Query add-in for those versions. The Power Query tools are found in Windows versions of Excel 2016+ in the Get & Transform section of the Data tab. Today, I will solve this with Power Query. ![]() I asked David if the key field only appears once in each file. I asked David if it is possible that one workbook has more records than the other. Both have the same data in column A, but the remaining columns are different. David from Florida asks today's question:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |