Snasui Excel Forum

Dear all,
I need your input to transpose data as per attached.
The required outcome is in workbook

Thk

Hi

Try this one, In short, the formula aligns closely with the requested outcome, with only minor differences

=IFERROR(VSTACK({"Group1","Group2","Value1","Value2"},LET(t,TOROW(A2:F19),HSTACK(WRAPROWS(FILTER(t,ISTEXT(t)),2),WRAPROWS(FILTER(t,ISNUMBER(t)),2)))),"")

Bigcat9Excel
BKK, Thailand