Pivoting columns

In this recipe, we will prepare the data set that we used in the Creating a population pyramid recipe of Chapter 2, Advanced Charts. The original file, which is a comma separated value (CSV) file, looks like the following:

Getting ready

To follow this recipe, download the file from BCStats using the following URL:

http://www.bcstats.gov.bc.ca/StatisticsBySubject/Demography/PopulationProjections.aspx.

When you download, make the following selections and click on Generate Output:

• Select British Columbia for Region

• Select all the years

• Select totals

• Select 5-Year Age Groups

  

Beside the result pane, click on the CSV icon at the top-right corner of the result pane to download the .csv file. Save the file as Population_Projections.csv.

How to do it...

Here are the steps to prepare the .csv file:

1. Click on New Data Source icon and connect to the text file in this recipe:

   

2. Select all the age groups that are presented as individual columns.

3. While all the age group columns are selected, right-click...