Forum Discussion
Convert a set of data for an animated bar chart
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
Memorable 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.
- AnonymousNot applicable
Your explanation has been very clear! Thank you very much!!!