Help: How could I automatically split a row in two when it passes a certain length?
I need to find a way to transform a single long column of up to 110 rows into multiple columns of maximum 40 rows. A40 to A79 should get moved to B0 to B39, etc.
Here's the kicker; I can't use VBA and any fix can't modify the data of the cells, and I CAN'T convert the column using a delimiter. I can't fraction the data of the cells in two. Can anyone give me any pointers? I'd really appreciate some help or guidance, I'm going crazy.