Re: do I need a table function to do this

Hello Kirk,

It looks like if you could "un-pivot" your t2, then you could do a join between that result and t1 and have your desired table.  Others may be able to suggest a more direct solution, but I've successfully adapted the one given here, with my own wide-format tables:

Good luck,

Bryan