Table transformation Google Sheets

user_2099376 0
Viewed 23

I'm trying to convert such table:

pic1

into such table:

pic2

First table is very big, and is being changed automatically by another user.

I'd like to use Google Sheets' query function. Any idea how?

Thanks in advance!

google-query-language flatten transpose google-sheets if-statement
1 Answers

use:

=INDEX(QUERY(SPLIT(FLATTEN(B1:D1&"×"&A2:A&"×"&B2:D), "×"), 
 "where Col2 is not null"))

enter image description here

user_56326290
Related