How can I transform rows to columns?

I have this table with data below and need help because I don't know which formula can I use to convert the table into the desired one.

I don't know if it's possible with ARRAYFORMULA, QUERY or TRANSPOSE

Current Data Set:

Date E1 E2 E3
4/01/2021 4,17% 3,53% 3,16%
11/01/2021 4,40% 3,69% 3,58%
18/01/2021 4,93% 4,39% 4,10%

Expected Output:

Date Type Metric
4/01/2021 E1 4,17%
4/01/2021 E2 3,53%
4/01/2021 E3 3,16%
11/01/2021 E1 4,40%
11/01/2021 E2 3,69%
11/01/2021 E3 3,58%
18/01/2021 E1 4,93%
18/01/2021 E2 4,39%
18/01/2021 E3 4,10%

Data Set (Google Sheets)

1 answer

  • answered 2022-05-06 20:54 player0

    use:

    ={"Date"\ "Type"\ "Metric"; INDEX(QUERY(SPLIT(
     FLATTEN(A2:A6&"×"&B1:L1&"×"&B2:L6); "×"); 
     "where Col3 is not null"; ))}
    

    enter image description here

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum