I'm looking to flip a table and can't seem to make it work with a combination of array formula and transpose. I'm looking for a formulae that can do this for larger data set

Please see the picture below for details. enter image description here

Tried array formulas, transpose, pivot table but with no success

CodePudding user response：

use:

=ARRAYFORMULA(QUERY(SPLIT(FLATTEN(A1:C1&"×"&A2:C10); "×"); 
 "where Col2 is not null"; ))

CodePudding user response：

You can use the TRANSPOSE function to invert rows and columns in Google Sheets not so:

type = TRANSPOSE Highlight the cells you want to change Press(