Suppose I have a program that returns data in one row of cells. The cells in the row repeat in groups of five. I have the ability to format the exported data, and want to place a semicolon or other character at the end of each group of five to produce a line break.

My objective is to have five columns, each with the same data category, so that 12345;12345;12345 becomes:

12345
12345
12345

in five columns.

Each digit represents a cell, so the above example would no longer be 15 cells in one row but 3 rows of 5 cells each.