Create a new table from columns from existing tables

Hi Hew, 

you can acheive this by using following steps:

Create New table using CrossJoin  & then calculated column : use concatenate to acheive desired result, please refer to snapshot below:

Create Newtable using CrossJoinCreate Calculated column shown as "Result" above and use concatenate ()

I hope that helps :)

Please dont forget to accept it as solution if it works :)