Splitting a cell by delimiter with formula. Warning: 312 splits needed for this.

[JakkeJakobsen]

Hi! I can't seem to find a way to split cells in Excel using formulas (I need it to be dynamic, so I can't use the built-in splitter).

What I have is up to 8 rows and 39 columns put into one cell. It's easy enough to get them spread out when I get them split up, but I can't split them. I can't find a working formula anywhere.

I usually work in Google Sheets, which has been way ahead of Excel for some years now, having stuff like =sort, which came to Excel last year or so, as well as =split, which splits by a delimiter, and it worked in my sheet. However, browser-based spreadsheets tend to get slow, mine is a professor in slow now, as I am using it to draw oil patterns for bowling lanes based on the input below. So I want an offline version that also works in Excel, as its a lot faster.

Sooo, any tips?

23 23 23 23 23 23 23 23 23 28 38 54 70 83 89 89 89 89 89 89 89 89 89 89 89 83 70 54 38 28 23 23 23 23 23 23 23 23 23 19 19 19 19 19 19 19 19 19 25 33 47 61 72 77 77 77 77 77 77 77 77 77 77 77 72 61 47 33 25 19 19 19 19 19 19 19 19 19 16 16 16 16 16 16 16 16 16 21 28 41 53 63 67 67 67 67 67 67 67 67 67 67 67 63 53 41 28 21 16 16 16 16 16 16 16 16 16 11 11 11 11 11 11 11 11 11 14 19 27 35 43 46 46 46 46 46 46 46 46 46 46 46 43 35 27 19 14 11 11 11 11 11 11 11 11 11 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <tbody> </tbody>

<tbody>
</tbody>

EDIT:
http://svolvarbowlingsenter.no/Patte...Norway2019.pdf

This is what I use this spreadsheet for, basically. This is done in Google Sheets, but I only lack this little split function from Google Sheets converted to Excel for it to work everywhere! :D

You can see the data I am looking to split in this PDF, top center, "Zone Oil Per Board Data". This was originally like the data in the table in my first post.

 

[Fluff]

My pleasure & thanks for the feedback