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% |
