Forum Discussion
Formula for moving a range of cells in one row to a new row
Hello All, On the small sample inserted below, you will see that every student has a unique number in Column A and each student has two rows of data. I would like to move the data so that every ...
=IFS(
DROP(REDUCE("",SEQUENCE(ROWS(A2:A21)),LAMBDA(u,v,VSTACK(u,SUM(N(TAKE(A2:A21,v)=INDEX(A2:A21,v)))=1))),1),
CHOOSEROWS(G2:L21,BYROW(A2:A21,LAMBDA(r,XMATCH(r,A2:A21,,-1)))),
1,
"")
With Excel for the web or Office 365 you can spill the result with this formula.
alternatively make a whole new table using:
=WRAPROWS(TOCOL(A2:L99),24,"")
then you could choose to copy->paste values and then delete redundant columns