Forum Discussion

Pussyk's avatar
Pussyk
Copper Contributor
Feb 13, 2021

Transposing a table

Hello,  I have a panel data table. The value of an item is recorded each year. The column has values corresponding to the year ( table 1). So, there are 11 years and 11 different columns. I want to ...
Formulas and Functions
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Feb 14, 2021

SergeiBaklan 

Just a glorified INDEX but specific to a particular array

= LAMBDA(itm,yr,
    LET(
    r0, XMATCH(itm, item),
    c0, XMATCH(yr, year),
    INDEX(array, r0, c0) )
    )

The intention is that the Lambda function should be the Name the user knows the array by and the reference within the formula is to the range that the array occupies.   That gives a more standard function notation than the INDEX formula.

 

Resources