Speed up Power Query with List.Buffer. Cache lists, cut recalculation, and slash refresh times for large datasets in Excel and Power BI.

Click the top half of the "Close And Load" button in the top-left corner of the Power Query Editor to load the table onto a new worksheet in the workbook.