3 Replies Latest reply on Aug 2, 2018 9:41 AM by Samuel Lebron

    Multiple Columns to Rows

    Samuel Lebron



           I have a challenge. I made a very simple example in excel since this relates to sensitive data.


      If you look at the picture... I need One column merging Columns F I L Next to that another column with G J M and one with H K N.

      Screen Shot 2018-07-16 at 2.19.04 PM.png


      The issue is that i need to keep the list intact but be able to measure L M N separately. I hope i'm explaining this correctly.

      Type 4 will be the only type that can sign as Auth 1 or Auth 2

      Screen Shot 2018-07-16 at 2.19.19 PM.png


      This is definitely not the end visualization but if I can get the data to this point I can then get to where I need.


      Appreciate any help!