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:

1. Go to the Select report columns screen;
2. Move the columns you want to be displayed in the report to the Selected Columns section.
3. 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).
4. 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.
5. After making the selection click on the Proceed button to get the output.

---

WITS Online Help

The World Bank, 2010