0

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)

player0
  • 124,011
  • 12
  • 67
  • 124

1 Answers1

0

use:

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

enter image description here

player0
  • 124,011
  • 12
  • 67
  • 124