Pivoting a table
Pivoting allows creating one separate column for each value of a given column. A good case is to create one separate column for each Year, and to fill them with Trade Value. The pivoting feature works with one statistic at a time.
To pivot a table:
- Go to the Select report columns screen;
- Move the columns you want to be displayed in the report to the Selected Columns section.
- Select the column on which to pivot in the Pivot Header dropdown. Note the available columns in this dropdown is limited (columns on which the data can be pivoted).
- Then in the Pivot Data select the columns whose value should appear in the pivot. Note: Here again the number of columns in this are limited to meaningful columns.
- After making the selection click on the Proceed button to get the output.
WITS Online Help
The World Bank, 2010