I have an excel sheet with the following layout. I'm trying to figure out a way to group the date columns into a single column. I know qlik reads excel file from top to bottom. Is there a way to maybe read this data set horizontally so that the dates are in a single column?
| | 2020_07 | 2020_08 | 2020_09 | 2020_10 | 2020_11 | 2020_12 | 2021_01 | 2021_02 | 2021_03 | 2021_04 | 2021_05 | 2021_06 |
| A | 12 | 13 | 9 | 5 | 10 | 4 | 3 | - | - | - | - | - |
| B | 12 | - | - | 5 | 8 | 68 | 1 | 5 | 7 | 8 | - | - |
| C | 11 | - | - | - | - | - | 3 | 4 | 2 | 8 | 6 | 8 |
