Forum Discussion
DGMalcolm
Mar 10, 2022Iron Contributor
Split column based on repeating data
Hey there, I've got a data set that has all of the info in the first column and I want to split it into columns based on every x number of rows. Like the data at the bottom where the rows contain...
- Mar 10, 2022Presuming your names are in A with no header and you're on 365, this is the idea:
=INDEX(FILTER(A:A,A:A<>""),SEQUENCE(COUNTA(A:A)/3,3,1,1),1)
Patrick2788
Mar 10, 2022Silver Contributor
Presuming your names are in A with no header and you're on 365, this is the idea:
=INDEX(FILTER(A:A,A:A<>""),SEQUENCE(COUNTA(A:A)/3,3,1,1),1)
=INDEX(FILTER(A:A,A:A<>""),SEQUENCE(COUNTA(A:A)/3,3,1,1),1)
- DGMalcolmMar 11, 2022Iron ContributorThis worked quite nicely, thank you!
~DGM~