2 Replies Latest reply: Feb 21, 2014 7:56 AM by Byron Van Wyk RSS

    Reverse crosstable table

      Hi All,

       

      I have 2 table like below

       

      TableA:

      Country,Value:

      A1,12

      A2,23,

      A3,34

       

      TableB:

      Country,Value:

      B1,122

      B2,232

      B3,342

       

       

       

      and I want to create a table like

       

      FinalTable:

      KEY,CountryA,CountryB

      1,A1,B1

      2,A1,B2

      3,A1,B3

      4,A2,B1

      5,A2,B2

      6,A2,B3

      7,A3,B1

      8,A3,B2

      9,A3,B3

       

      Whats the easiest way to do that inside the script??