Converting rows to columns
In most datasets, each row belongs to a different element, such as a different match or a different student. However, there are datasets where a single row doesn't completely describe one element. Take, for example, the real-estate file from Chapter 6, Transforming Your Data by Coding. Every house was described through several rows. A single row gave incomplete information about the house. The ideal situation would be the one in which all the attributes for the house were in a single row. With Pentaho Data Integration (PDI), you can convert the data into this alternative format. You will learn how to do it in this section.
