Forum Discussion
Solved
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...
- 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)
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)
- This worked quite nicely, thank you!
~DGM~
