1 Reply Latest reply on May 31, 2013 4:20 AM by Robin Kennedy

    Formatting data: one line per data point?

    Ralph Lindenfeld

      Folks-

       

      I have another project involving multiple data sets. If I recall correctly, I need to set it up so that one data "point" is per line.

       

      Below I'm pasting some data showing how I'm getting the data, as well as how I believe it needs to be set up for Tableau.

       

      Can someone confirm this is correct, before I go further?

       

      Thanks,

       

      RL

       

      What I get:AgeType19961997199819992000
      20contribution55555
      21contribution1010101010
      25contribution3030303030
      AgeType19961997199819992000
      20withdrawal55555
      21withdrawal1010101010
      25withdrawal3030303030
      What I need?AgeTypeYear
      20contribution1996
      20withdrawal1996