Alternative to Power Query

Question

Looking for suggestions for how to pull all data from one worksheet to another based on a value in one or two columns. I thought I might be able to do this with Power Query but I use a Mac and that does not appear to be supported. Very simplified example attached. (I am not interested in using a program to run a Windows environment on my Mac)

theantony · Answer

ecgrim&nbsp;, Here's the Filter function in action. I converted the original data into a Table to make the solution more robust. Hope this helps.

mathetes · Answer

ecgrim&nbsp;&nbsp;If you have the newest version of Excel on your Mac, the FILTER function will perform exactly what you want.&nbsp;And if you add SORT, it would put them into alphabetical order (or reverse) based on a column of your own choosing.&nbsp;If rather than an image you'd upload the actual sample spreadsheet, I or somebody else could demonstrate. But my guess is that you can figure it out. In fact, to help, here's a YouTube video that covers these new functions.&nbsp; https://www.youtube.com/watch?v=9I9DtFOVPIg&nbsp;

ecgrim · Answer

Thanks&nbsp;mathetes! I appreciate your guidance. If you have time, I would love a demonstration. I will also watch the video you provided.

Forum Discussion

Alternative to Power Query

3 Replies

Resources