NEXT CELL VALUE FROM THE SAME CODE

Question

Hi There, in tab labelled "DATA" I need to basically transpose the info into the next "OUTPUT" tab.
Some style numbers have multiple colour options but I need these to run in rows rather than down columns.. What's the easiest way to do this? Some sort of INDEX/XMATCH?

patrick2788 · Answer

PAULBRAGASON&nbsp;If you have 365, you can use the standard REDUCE/VSTACK method:=LET(
    styles, SORT(UNIQUE(StyleNumber)),
    pivot, LAMBDA(acc, v,
        LET(
            record, TOROW(FILTER(ColourInfo, StyleNumber = v), , 1),
            IFERROR(VSTACK(acc, HSTACK(v, record)), "")
        )
    ),
    DROP(REDUCE("", styles, pivot), 1)
)

Forum Discussion

NEXT CELL VALUE FROM THE SAME CODE