Thanks! that 'pivots' my data perfectly,

The only thing is how do i create a new table matching this output?

My goal is to create a 2nd table that can be used...

Thanks for such a quick response, i will try this out tomorrow.