Keep running into this type of problem. I tried using scan by col with tocol/torow and then wrapping but no luck.MaybeExcel Formula:=LET(a,TRANSPOSE(TAKE(AB12#,12))-TAKE(DROP(AB12#,1),12),VSTACK(SEQUENCE(,COLUMNS(a))&" "&"/"&" "&SEQUENCE(ROWS(a)),a))
Actually if I torow both then I can get that by wrapcol however is there no easier way to do this with maybe scan/map/byrow?Keep running into this type of problem. I tried using scan by col with tocol/torow and then wrapping but no luck.
View attachment 110877
I apologize for the confusion. The first image is the result of your Let function. In that post I said or tried to say: I ran into this issue before I created this post, I tried fixing it using scan by col in torow.I have no idea as
a) You have posted a number of images that tell us absolutely nothing.
b) You have not said anything about my suggestion.
I want this as my output. just in reverse but my question is there an easier way to get here?Without knowing what your data is, or what you want as an output, it's almost impossible to say.
=LET(a,TRANSPOSE(TAKE(AB12#,12))-TAKE(DROP(AB12#,1),12),SORTBY(VSTACK(SEQUENCE(,COLUMNS(a))&" "&"/"&" "&SEQUENCE(ROWS(a)),a),VSTACK(SEQUENCE(ROWS(a),,,2),SEQUENCE(ROWS(a),,2,2))))