If you have used Power Query, you know that it has options that allow you to keep or discard certain columns. If you’re an Excel user coming through a Microsoft 365 subscription, there are a few new functions available to you to do a similar thing. As a result they create a dynamic array with columns or rows extracted from a given matrix that are retained or discarded.