Changing rows to columns

[stijnvalkenburg]

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!

[stijnvalkenburg]

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

[Thiago_Justen_]

It would great if you could mark those answers that were helpful to you solve this thread.

[OmarBenSalem]

This was not the correct answer...

[Thiago_Justen_]

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.