![kutools excel advanced combine rows not working kutools excel advanced combine rows not working](https://cdn.soft112.com/kutools-for-excel/00/00/00/BQ/000000BQK5/pad_screenshot.png)
If we need to return multiple results from a table then the lookup functions are unlikely to work. As we can see, there is another match further down that VLOOKUP() has ignored. Let’s take a look at how a VLOOKUP() works:Įven this simple example shows one of the issues of the lookup functions: they only return the first match. The VLOOKUP() function assumes that your data is arranged as a table with different elements of the information in different columns.
KUTOOLS EXCEL ADVANCED COMBINE ROWS NOT WORKING HOW TO
The V and H in the names of these two functions refer to Vertical and Horizontal respectively, so the good news is that once you’ve learnt how to use VLOOKUP(), HLOOKUP() should be easy, as it works in exactly the same way, but with data arranged in rows as opposed to columns. jpg |c:/someroute/| ProductC | c:/otherpath/ | productC-2.jpg|Īs I mentioned above, I'm trying to create a renaming function, so files with random names, get the name of the product they are representing.Although the Excel lookup functions can seem quite straightforward, it’s very easy to get the wrong answer if you don’t fully understand how they work.Įxcel does have an additional lookup function: LOOKUP() but this is only included for compatibility with older spreadsheet applications, so we’ll concentrate on VLOOKUP() and HLOOKUP(). jpg |c:/someroute/| ProductC | c:/otherpath/ | productC-1.jpg|
![kutools excel advanced combine rows not working kutools excel advanced combine rows not working](https://cdn.ablebits.com/_img/d-19/blog-adv/merge-cells-2/slide-3.png)
jpg |c:/someroute/| ProductC | c:/otherpath/ | productC-3.jpg| jpg |c:/someroute/| ProductC | c:/otherpath/ | productC-2.jpg| jpg |c:/someroute/| ProductA | c:/otherpath/ | productA-1.jpg| jpg |c:/someroute/| ProductA | c:/otherpath/ | productA-2.jpg| I'm guessing I should use some kind of index column that counts the duplication of values in Product Name but I don't really know that, nor I understand why is it not working, but any of the options above output something like this: | Name |Extension|Folder Path |Product Name|Destination Path| ImageID |
![kutools excel advanced combine rows not working kutools excel advanced combine rows not working](https://www.mazterize.com/wp-content/uploads/2019/07/Kutools-for-Excel-min.jpg)
jpg |c:/someroute/| ProductB | c:/otherpath/ | productB-1.jpg| | 0003 | sku0003 | ProductC |productC-1.jpg, productc-2.jpg, productc-3.jpg|ĭesired output (I'm building a dynamic renaming function, to rename all files with the names of ImageIDs: | Name |Extension|Folder Path |Product Name|Destination Path| ImageID | Query Table 2: |productid|productSKU|Product Name| ImageIDs | jpg |c:/someroute/| ProductC | c:/otherpath/ | jpg |c:/someroute/| ProductB | c:/otherpath/ | jpg |c:/someroute/| ProductA | c:/otherpath/ | Query Table 1: | Name |Extension|Folder Path |Product Name|Destination Path| I am not an expert in Power Query and I've tried several things, including different tipes of join (left, full, right, etc.) and the result is always the same. I'm trying to merge two queries using one column (which contains duplicate values, although the exact same amount of duplicates for the same values in both queries) as key but whenever I expand the merged table, all rows get twice the duplicates.