Forum Discussion

Brass Contributor

Oct 21, 2025

Solved

A button to transpose data into a destination table

Hi, I have a table filled with data that I need to be pasted into a final blank table but the destination table is larger than the original table. Also the data needs to be sorted by one column and t...

excel

Macros and VBA

SergeiBaklan

Oct 21, 2025

In general that could be formula if locations of Source and Destination are predefined

=LET(
   source,  TRIMRANGE($A$4:$C$10000),
   IDs,     SORT( TRIMRANGE($E$4:$E$10000) ),
   headers, CHOOSECOLS($A$3:$C$3, {1,3,2} ),
   VSTACK(
       headers,
       HSTACK(
          IDs,
          XLOOKUP(IDs, CHOOSECOLS(source,1), CHOOSECOLS(source,3), ""),
          XLOOKUP(IDs, CHOOSECOLS(source,1), CHOOSECOLS(source,2), "")
      )
  )
)