You'll need to flip your data first and then use a Text to Columns tool to split all the value to rows at the same time. Then just flip it back. I added in a couple extra steps on the workflow to clean up some empty values.
@Pingu - In this case, it means nothing. Normally it is the assigned tile of the record, so it can be used when you're splitting data into equal sums etc. The Tile Sequence number is the important one here, since I'm using it as a record id for each grouping.