Forum Discussion
Translate index match in Excel Power Query
Hi! It is too heavy for Excel to execute the function =index(a:a, match(true, exact(b2, c:c), 0)) for +800 rows. I thus want to do this via Power Query in Excel instead (I loaded the data using g...
Hi!
Thanks for the reply. What do you mean by extracting column 1? Also, in your image your extra column shows text1 instead of text3 which is the desired result.
Hi TestssonNow
Select Merge on the ribbon, merge with the itself
That yields a nested table as result, which can be expanded, with the sideward arrows
Select Column1, from the available fields
Thank you for the explanation, much appreciated! I have a dataset with +800k rows and that seemed to be too much with the expansion solution (i.e. Power Equery says it ran out of memory and doesnt complete the process). Is there an m code / Power Query Custom column code I could use to solve this?