Forum Discussion

JTMoneyBest's avatar
JTMoneyBest
Copper Contributor
Apr 05, 2022
Solved

Help transposing rows of data with repeated headings into columns with unique headings

Hello, I always receive raw data in the form of 1x9 rows of numerical data. Each cell of the row is labeled S1, S2, S3, etc. (usually up to S4) but the labels can be repeated and in random order each...
  • Lorenzo's avatar
    Lorenzo
    Apr 05, 2022

    JTMoneyBest 

     

     

    in K2 and copy right:

    =TRANSPOSE(FILTER($A2:$I2,$A1:$I1=K1))

Resources