Using column header as values

[Nicolas]

Hello experts,

I have a tough one for you:

I have a bunch of columns like this:

      Qry1  Qry2  Qry3  Qry4  Qry5  Qry6  Qry7  Qry8  Qry9  Qry10

1      N       N        N       N       N       N        N      N      Y       N

2      N       N        Y       N       N        N        N      N      N      N

3      Y       N        N       N       N       N        N      N       N      N

Notice the 'Y's?

Well I need to reduce this to one column using the headers where the value is 'Y'. the output should look like this:

       MyNewColumn

1             Qry9

2             Qry3

3             Qry1

Basically use the column header where there is a 'Y'. I guess I need a calculation column of some sort but I haven't found anything on the net as to using headers as value.

Any help is appreciated.

[MFelix · Accepted solution]

Hi @Nicolas,

In the query editor do as follows:

1 - Select all your columns

2 - Unpivot columns

3 - FIlter Y values

Regards

Mfelix