11 Replies Latest reply on Dec 6, 2013 8:01 AM by George Nguyen

    Transforming Data within Tableau

    George Nguyen

      Is it possible to take a dimension and convert it to a measure AND split the individual dimension values into individual measures?

       

      I would like to take each unique value for IndicatorName (column F) and create a column for each unique value. For example, the IndicatorName "GNI per capita" will now be column J with its values for the corresponding country is correctly populated.

      TransposingData.PNG.png

      I've attached the Excel file which contains two spreadsheets:

      - Original = shows the report format as it is now

      - Transformed = shows how I want to reformat the data

       

      How should I go about doing this?

       

       

      Thanks,

      George