Forum Discussion

bofus's avatar
bofus
Copper Contributor
Dec 02, 2022

colum split

I have a single column of 70K plus entries that I want to split into multiple columns of about 50 each. Any suggestions?
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Dec 04, 2022

bofus 

As variant

hWrap = LAMBDA(array, n,
    LET(
        nR, ROWS(array),
        IF(
            nR <= n,
            array,
            LET(a, hWrap(DROP(array, n), n), IFNA(HSTACK(DROP(array, n - nR), a), ""))
        )
    )
)

Resources