6 Replies Latest reply: Nov 13, 2016 10:25 PM by Sasi Vardhan KV RSS

    Convert Rows to Columns for relationship

    Evgenii Senko

      Hi,

       

      Below are two tables.

       

      Table1

        

      HorizontNameRowNameColumnName
      1Name11Column1
      1Name12Column2
      1Name13Column3
      1Name14Column4
      2Name21Column5
      2Name22Column6
      2Name23Column7
      2Name24Column8
      3Name31Column9
      3Name32Column10
      3Name33Column11
      3Name34Column12

       

        Table2 

      Column1Column2Column3Column4Column5Column6Column7Column8Column9Column10Column11Column12
      777777777777777777777777
      444444444444444444444444

       

      I need convert rows from Table1 to columns and make relationship between two tables.

       

      Grateful for any solution.