Hi Everybody,
I have data in excel which is arranged in the following format:
| | Initiative 1 | Initiative 2 | Initiative 3 | Initiative 1 | Initiative 2 | Initiative 3 |
| Sl.No. | Brand 1 | Brand 1 | Brand 1 | Brand 2 | Brand 2 | Brand 2 |
| 1 | | | | | | |
| 2 | | | | | | |
| 3 | | | | | | |
And I want to convert it into a format which should look like this:
| Sl.No. | Initiatives | Brand |
| 1 | Initiative 1 | Brand 1 |
| 1 | Initiative 2 | Brand 1 |
| 1 | Initiative 3 | Brand 1 |
| 1 | Initiative 1 | Brand 2 |
| 1 | Initiative 2 | Brand 2 |
| 1 | Initiative 3 | Brand 2 |
| 2 | Initiative 1 | Brand 1 |
| 2 | Initiative 2 | Brand 1 |
| 2 | Initiative 3 | Brand 1 |
| 2 | Initiative 1 | Brand 2 |
| 2 | Initiative 2 | Brand 2 |
| 2 | Initiative 3 | Brand 2 |
| 3 | Initiative 1 | Brand 1 |
| 3 | Initiative 2 | Brand 1 |
| 3 | Initiative 3 | Brand 1 |
| 3 | Initiative 1 | Brand 2 |
| 3 | Initiative 2 | Brand 2 |
| 3 | Initiative 3 | Brand 2 |
While I am able to do it in the excel I was wondering if it would be possible to do it in Qlik Sense also?
Thank You in Advance
