Thank you MarvinP - The attachment does help. I think we may have an issue here as I don't have PowerQuery. Is there another way to accomplished the same results in your Max Value pivot?

What I'm trying to accomplish is consolidated data for each employee in one row across all columns (which the MAX pivot you provided seems to do what I'm trying to explain).

I'm having a hard time getting to the end result through several methods. Find GO TO Special - blanks will not just remove the blank cells for each employee and shift everything up. Also when using a formula such as IndexMatch or vlookup, it does not account for cells with values below which are below the first row of that it find the lookup range.

We are currently working on Excel 2013. If I'm not mistaken, Power Query is only available on Excel 2016, right?

Again thanks again MarvinP for taking time out and helping me with this problem