Power Query - List.Buffer to do a Million row Lookup

In this video i show you how to do a composite key lookup with a million rows of data using List.Buffer. #dataanalytics #data #datatransformation #mquery #powerbi #powerquery #powerbidesktop #excel #exceltips File Link https://github.com/jbotes/powerbiTutorials/blob/main/PQ_BUFFER_VIDEO.xlsx Noteworthy techniques - list of lists (double list in a list) - nested lets List.ReplaceMatchingItems https://powerquery.how/list-replacematchingitems/ Table.TransformColumnTypes https://powerquery.how/table-transformcolumntypes/ Text.split https://powerquery.how/text-split/ List.Buffer https://powerquery.how/list-buffer/