Hello @anon70503803 ,
The outer join didn’t do anything to break out the columns, it actually looked exactly the same after applying that. However, the “Labels to fields” transformation did exactly what I needed as now I have everything broken out.
Thanks for leading me down the correct path to solution!!
Rob!