Overall, it was tedious and error-prone work that nearly made me give up. That’s when I finally considered using the one feature Excel enthusiasts always talk about—Power Query.

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