table to column macro, vlookup

add macro to pivot table.xlsm, add reference for vlookup, add formula to
combine column header and row header with the cell content. tomorrow
need to test multiple criteria vlookup because some duplicate lengths.