How to load ONE column of Excel with three types of values into THREE columns QlikView?

[f1234567]

We have one column to load, and every third line contains the same type of data:

i.e.

Firstname1

Name1

City1

Firstname2

Name2

City2

Firstname3

Name3

City3

...

As said, the structure of the lines in the one and only column of my source (Excel) are always the same.

What I would like to have is a table in QlikView to show the values like this:

Firstname      Name     City

-----------------------------------------

Firstname1    Name1   City1

Firstname2    Name2   City2

Firstname3    Name3   City3

...

Thanks for any idea!

[Gysbert_Wassenaar · Accepted solution]

A generic load could do the trick. See attached example.

[f1234567]

Many thanks, Gysbert!

Very helpful. Great idea!

Best Regards

Frank