How does this look. It should be easy to adjust for any number of columns.
vlookup_pivot_join.knwf (74.2 KB)