Forum Discussion
roniexcel2020
Oct 13, 2020Copper Contributor
copying spread words to one column
Hi I teach basic excel and a student of mine asked me a question i did not know the answer to. For some reason he has got an excel sheet with lots of words spread in over columns and rows, some wit...
SergeiBaklan
Oct 13, 2020Diamond Contributor
One more variant
is
=SORT(UNIQUE(INDEX(B18:D23,MOD(SEQUENCE(6*3,,0),6)+1,SORT(MOD(SEQUENCE(6*3,,0),3)+1))))