Returning Column Name of first non- Null value

[orangebloss]

I have a CSV file I'm using as a source, I'm needing to return the column name of the first non-null value in a row. 

In Excel I'd use a simple index match. I've worked out how to return the first non null value but still can't quite fathom how to return the column name.

Any help very much appreciated.

[slorin · Accepted solution]

Add a List.RemoveFirstN

List.Skip(List.RemoveFirstN(List.Zip({Record.FieldValues(_), Record.FieldNames(_)}),4), each _{0}=null){0}{1}

Stéphane 

[orangebloss]

Brilliant thank you!!!

[slorin]

Hi

Add a new column

List.Skip(List.Zip({Record.FieldValues(_), Record.FieldNames(_)}), each _{0}=null){0}{1}

 Stéphane

[orangebloss]

Thanks - that's almost there, however the columns I'm searching start at column 5 (first four columns are populated) how would I change this to accomodate this?

It also seems to return the same result for every row?