p45cal

Thank you for the revision and solution to my post. This is exactly what I was trying to accomplish. As for the number of columns, I removed irrelevant columns to simplify things and it's going to stay this way.

Thank you for sharing the discussion about fill down in excelguru. I never experienced this issue before, but I found the discussion to be very educational.

My goal moving forward is to learn power query and power BI as much as possible.

Many thanks!