1 Reply Latest reply on Aug 21, 2018 11:36 AM by chiranjeevi prathipati

    How to unmerge columns that share dates

    Alessandro Sardone

      Hello everyone,

       

      I have some dummy data that I arranged in the following picture:

       

      tableau1.PNG

       

      My goal is to insert another column, that would add another 5 sizes (mega through micro) to this table but containing the Audit Size field. When I drop the field into columns however, I get something totally wrong:

       

      tableau2.PNG

       

      Is there any way to achieve what I am trying to do?

       

      Thanks!

        • 1. Re: How to unmerge columns that share dates
          chiranjeevi prathipati

          Hi ,

           

          Your data should be like this for what you want to achieve

           

              

          MonthSizeReported countAudited count
          July whale11
          July Large23
          July Medium11
          July Small14
          July Micro15
          Augustwhale42
          AugustLarge22
          AugustMedium12
          AugustSmall12
          AugustMicro11

           

          Or May be something like this

           

              

          MonthReported SizeMonthAudited Size
          July whaleJuly whale
          July LargeJuly Large
          July LargeJuly Large
          July MediumJuly Large
          July SmallJuly Medium
          July MicroJuly Small
          AugustwhaleJuly Small
          AugustwhaleJuly Small
          AugustwhaleJuly Small
          AugustLargeJuly Micro
          AugustLargeJuly Micro
          AugustMediumJuly Micro
          AugustSmallJuly Micro
          AugustMicroJuly Micro
          Augustwhale
          Augustwhale
          AugustLarge
          AugustLarge
          AugustMedium
          AugustMedium
          AugustSmall
          AugustSmall
          AugustMicro

           

          In this case you should blend the data excels.