Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
@User5878 look at the crosstable load