Capture Header Name in Cell Rows based on last non-null column.

[mtd_excel]

Not sure how to ask this question, but hopefully with the picture below it will be clear.

I was able to add my first CUSTOM COLUMN(Col U) in PowerQuery using the below formula and it worked well to retrieve the last Non-Null field in my list of dates.

CUSTOM COLUMN = List.Last(List.RemoveNulls({[#"WHS"],[#"CUSTOMS"],[#"DISPATCH"]}))

Now I can't seem to figure out if its possible to add the 2nd Custom Col. (COL V). Where it looks at the same information and picks the last non-null cell, but populates with the name of the header. (So Example below - Last non null for Row 1 is Col S, value = 3/27, and header = DISPATCH)

Does this make sense and/or is this possible?

 

[sandy666]

Table.ColumnNames()
Table.Schema()

 

[mtd_excel]

Thank you Sandy, I will check those functions out.

 

[sandy666]

You are welcome

for the second you'll need
Table.SelectColumns(Table.Schema(your_table),"Name")