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

mtd_excel

New Member
Joined
Mar 30, 2020
Messages
2
Office Version
  1. 2013
Platform
  1. Windows
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?
TABLE2Capture.JPG
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
You are welcome

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

Forum statistics

Threads
1,223,247
Messages
6,171,007
Members
452,374
Latest member
keccles

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top