Excel Unplugged

Tag Archives: Lists

Extract Columns that Contain Actual Values

We often work with large datasets containing multiple columns, but only need a few. In this tutorial we’ll show how to extract the columns that contain Actual ...

Transforming a Table to Top 10 (by values) and Others with Power Query

How to get the top 10 values in a table, and an aggregate for all the other data? Our goal today is to turn a table of countries with attributes into a table of ten ...

Filtering a Table to a List of Values in Power Query or Power BI

Knowing how to use Lists in Power Query or Power BI is like a superpower. This Post will show you how to filter a Table to a Dynamic List of Values by using Lists in ...