Reading files with some fields occupying two or more rows

When you use one of the Kettle steps devoted for reading files, Kettle expects one entity per row. For example, if you are reading a file with a list of customers, then Kettle expects one customer per row. Suppose that you have a file organized by rows, where the fields are in different columns, but some of the fields span several rows, as in the following example containing data about roller coasters:

Roller Coaster      Speed     Location                   Year
Kingda Ka           128 mph   Six Flags Great Adventure
                              Jackson, New Jersey        2005
Top Thrill Dragster 120 mph   Cedar Point
                              Sandusky, Ohio             2003
Dodonpa             106.8 mph Fuji-Q Highland
                              FujiYoshida-shi            2001
                              Japan
Steel Dragon 2000   95 mph    Nagashima Spa Land
                              Mie                        2000...