Run a VBA code to remove blank cells and return first non-blank cell with multiple criterias

[gracecyl]

Hi everyone,

This is the sample text.
What I require is to remove all the blank cells and lookup the first non-blank cell value as each category for each Name has ONLY one unique value.

So this:
-- corrupted image removed --

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...lank-cell-multiple-criterias.html#post5072328

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

As you have had a reply to the other thread, I've locked this one.