OBIEE Pivot table with carriage return

One of my customers wanted some data presented in a pivot table with a maximum of 5 columns. If more data is available then a sort of carriage return should be given and continue on next line. (A sort of DTP)

First I concatenated all the data into 1 cell:

Then I determined the ColomnNumber and RowNumber for each element.

And finally put it in a pivot table:

Don't forget to set the aggregate level for the measure to first!