Filter function to extract selected columns by Header match

AliGW and Fluff13 gave me good solutions for this but I need a slight variation.

I am looking for a function which pulls data from blue table based on Deisired outcome header labels.

Desired outcome has preset headers and I need to filter from blue table from the associated Data columns.

Hi KerahJoy,

I'm not sure what you are asking in this question. Does G1 change values and you want to filter on that? Can you give a better example??

Have you seen AutoFilters in a Table?? Is that really what you are looking for?

Delete delete

With Power Query

let

Please Login or Register  to view this content.

Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

- Follow this link to learn how to install Power Query in Excel 2010 / 2013.

- Follow this link for an introduction to Power Query functionality.

- Follow this link for a video which demonstrates how to use Power Query code provided.

If you wish to select the columns as a variable, then look at the attached where you select the column names and then select Refresh All in the Data Tab. This is called a parameter query in Power Query