Forum Discussion

DGMalcolm's avatar
DGMalcolm
Iron Contributor
Mar 10, 2022
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...
excel
  • Patrick2788's avatar
    Patrick2788
    Mar 10, 2022
    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)
harshulz's avatar
harshulz
Iron Contributor
Mar 11, 2022

DGMalcolm 

there is a tricky way, slight thousands times better in my overview
and this will help of macros will get perfect result

=FILTER($B2:$B1000,$A2:$A1000=E2," ")

 

 

 

Resources