Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Convert a set of data for an animated bar chart

Hello everybody, I need your help.
I have a set of data like this:
And I need to convert it into this:
I have to do that because I want to show these data into an animated bar chart. Can you please help me?
  • Anonymous 

    Here are the steps to follow in Query Editor/Transform Data.

     

    Input

    Step 1:

    Remove Column2(Right click -> Remove)

     

    Step 2:Promote Headers 

    Home->Use First Row as Headers

    Col 1 is empty; 2000 as column 2 name and 2001 as column 3 name

     

    Step 3: Unpivoted Columns

    Choose col 2 and 3 , Transform-> Unpivot Columns

     

    Step4 : Rename Column names

     

    Output

     

    If this helps, mark it as solution.

    Kudos are good too.

     

2 Replies

  • VasTg's avatar
    VasTg
    Icon for Memorable Member rankMemorable Member

    Anonymous 

    Here are the steps to follow in Query Editor/Transform Data.

     

    Input

    Step 1:

    Remove Column2(Right click -> Remove)

     

    Step 2:Promote Headers 

    Home->Use First Row as Headers

    Col 1 is empty; 2000 as column 2 name and 2001 as column 3 name

     

    Step 3: Unpivoted Columns

    Choose col 2 and 3 , Transform-> Unpivot Columns

     

    Step4 : Rename Column names

     

    Output

     

    If this helps, mark it as solution.

    Kudos are good too.

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Your explanation has been very clear!  Thank you very much!!!