Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have like 20 seperate excels with below format. Is there an easy way to change the rows to columns?
Field | Value |
---|---|
ScoreA | 1 |
ScoreB | 3 |
ScoreC | 5 |
So I want it in Qlik Sense like this:
ScoreA | ScoreB | ScoreC |
---|---|---|
1 | 3 | 5 |
Thanks!
In the end I used the Generic Load option and then used joins to create 1 table using a column I created based on the filename
It would great if you could mark those answers that were helpful to you solve this thread.
This was not the correct answer...
As omarbensalem said, I think your choice of correct answer was not very appropriate. Considering that some members were willing to help, it would be good to give some value to their answers.